Chapter 7: Make long tables easier to read
Exercise 33: Convert to a table with banded rows
Task
Convert the range to a table to add header colors, banded rows, and filters in one step.
Moves 0 (target 1)21 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 | |||||
| 10 |
Convert the range to a table to add header colors, banded rows, and filters in one step.
This drill is for computer screens. On a phone you can review the steps.
- Select a cell in the table
- Ctrl + T (or Insert > Table)
- Make sure "My table has headers" is checked and click OK
Key takeaway
A table keeps its colors when you add rows. You can't merge cells inside a table.
See how to make a table in Excel for details.