Chapter 7: Make long tables easier to read
Exercise 31: Center the title without merging
Task
The title is merged across A1:D1. Unmerge it and use Center Across Selection instead.
Moves 0 (target 2)2 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 | Sales, November 2026 | ||||
| 2 | |||||
| 3 | Item | Rep | Qty | Amount | |
| 4 | Notebook | Smith | 12 | 18000 | |
| 5 | Ballpoint pen | Johnson | 5 | 1250 | |
| 6 | Clear folder | Williams | 30 | 36000 | |
| 7 | Sticky notes | Brown | 8 | 2400 | |
| 8 | Total | 55 | 57650 | ||
| 9 | |||||
| 10 | |||||
The title is merged across A1:D1. Unmerge it and use Center Across Selection instead.
This drill is for computer screens. On a phone you can review the steps.
- Select A1:D1
- Click Home > Merge & Center to unmerge (Alt → H → M → U)
- Ctrl + 1 > Alignment > Horizontal: Center Across Selection, then OK
Key takeaway
It looks the same as merging but doesn't get in the way of selecting columns or sorting.
See merging cells and centering without merging for details.