Chapter 2: Print settings

Exercise 7: Print the header row on every page

Task

The staff list runs onto a second page with no header. Print row 1 on every page.

Moves 0 (target 1)1 difference(s) from the model

File

Font

Alignment

Number

Styles

Cells

A1Press and release Alt to show KeyTips (Windows). Ctrl + 1 opens Format Cells, Ctrl + Z undoes.

	A	B	C	D
1	Employee ID	Name	Department
2	E-001	Smith	Admin
3	E-002	Johnson	Sales
4	E-003	Williams	Finance
5	E-004	Brown	HR
6	E-005	Jones	Admin
7	E-006	Garcia	Sales
8	E-007	Smith	Finance
9	E-008	Johnson	HR
10	E-009	Williams	Admin
11	E-010	Brown	Sales
12	E-011	Jones	Finance
13	E-012	Garcia	HR
14	E-013	Smith	Admin
15	E-014	Johnson	Sales
16	E-015	Williams	Finance
17	E-016	Brown	HR
18	E-017	Jones	Admin
19	E-018	Garcia	Sales
20	E-019	Smith	Finance
21	E-020	Johnson	HR
22	E-021	Williams	Admin
23	E-022	Brown	Sales
24	E-023	Jones	Finance
25	E-024	Garcia	HR
26	E-025	Smith	Admin
27	E-026	Johnson	Sales
28	E-027	Williams	Finance
29	E-028	Brown	HR
30	E-029	Jones	Admin
31	E-030	Garcia	Sales
32	E-031	Smith	Finance
33	E-032	Johnson	HR
34	E-033	Williams	Admin
35	E-034	Brown	Sales
36	E-035	Jones	Finance
37	E-036	Garcia	HR
38	E-037	Smith	Admin
39	E-038	Johnson	Sales
40	E-039	Williams	Finance
41	E-040	Brown	HR
42	E-041	Jones	Admin
43	E-042	Garcia	Sales
44	E-043	Smith	Finance
45	E-044	Johnson	HR
46	E-045	Williams	Admin
47	E-046	Brown	Sales
48	E-047	Jones	Finance
49	E-048	Garcia	HR
50	E-049	Smith	Admin
51	E-050	Johnson	Sales
52	E-051	Williams	Finance
53	E-052	Brown	HR
54	E-053	Jones	Admin
55	E-054	Garcia	Sales
56	E-055	Smith	Finance
57	E-056	Johnson	HR
58	E-057	Williams	Admin
59	E-058	Brown	Sales
60	E-059	Jones	Finance
61	E-060	Garcia	HR
62
63

The staff list runs onto a second page with no header. Print row 1 on every page.

This drill is for computer screens. On a phone you can review the steps.

Page Layout → "Print Titles" (Alt → P → I)
Enter $1:$1 in "Rows to repeat at top" and click OK

Key takeaway

The header appears on page 2 and beyond, so it is always clear which column is which.

See how to make a table in Excel for details.

← Back to all exercises