Chapter 4: Borders and colors
Exercise 15: Add lines under headers and around the total
Task
Add a thick line under the headers, a thin line above the total row, and a double line below it.
Moves 0 (target 2)16 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 | Item | Rep | Qty | Amount | |
| 2 | Notebook | Smith | 12 | 18000 | |
| 3 | Ballpoint pen | Johnson | 5 | 1250 | |
| 4 | Clear folder | Williams | 30 | 36000 | |
| 5 | Sticky notes | Brown | 8 | 2400 | |
| 6 | Total | 55 | 57650 | ||
| 7 | |||||
| 8 |
Add a thick line under the headers, a thin line above the total row, and a double line below it.
This drill is for computer screens. On a phone you can review the steps.
- Select A1:D1, then Home > Borders > Thick Bottom Border (Alt → H → B → H)
- Select A6:D6, then Home > Borders > Top and Double Bottom Border (Alt → H → B → U)
Key takeaway
The double line under a total marks where the calculation ends.
See How to add borders for details.