Chapter 7: Make long tables easier to read
Exercise 30: Freeze the header row
Task
The headers disappear when you scroll down. Freeze the header in row 1.
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 | E | |
|---|---|---|---|---|---|
| 1 | Slip | Rep | Qty | Amount | |
| 2 | S-001 | Johnson | 8 | 4900 | |
| 3 | S-002 | Williams | 15 | 8600 | |
| 4 | S-003 | Brown | 2 | 3300 | |
| 5 | S-004 | Jones | 9 | 7000 | |
| 6 | S-005 | Smith | 16 | 1700 | |
| 7 | S-006 | Johnson | 3 | 5400 | |
| 8 | S-007 | Williams | 10 | 9100 | |
| 9 | S-008 | Brown | 17 | 3800 | |
| 10 | S-009 | Jones | 4 | 7500 | |
| 11 | S-010 | Smith | 11 | 2200 | |
| 12 | S-011 | Johnson | 18 | 5900 | |
| 13 | S-012 | Williams | 5 | 9600 | |
| 14 | S-013 | Brown | 12 | 4300 | |
| 15 | S-014 | Jones | 19 | 8000 | |
| 16 | S-015 | Smith | 6 | 2700 | |
| 17 | S-016 | Johnson | 13 | 6400 | |
| 18 | S-017 | Williams | 20 | 10100 | |
| 19 | S-018 | Brown | 7 | 4800 | |
| 20 | |||||
| 21 |
The headers disappear when you scroll down. Freeze the header in row 1.
This drill is for computer screens. On a phone you can review the steps.
- View > Freeze Panes > Freeze Top Row (Alt → W → F → R)
Key takeaway
To freeze both the header row and the first column, select B2 and use Freeze Panes.
See how to make a table in Excel for details.