Chapter 8: Case studies
Exercise 34: Tidy an expense list for your team
Task
Make the headers dark green with white bold text, add thousands separators to the amounts, fit the column widths, and hide gridlines.
Moves 0 (target 6)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 | |
|---|---|---|---|---|
| 1 | Date | Description | Amount | |
| 2 | ###### | Train fare (Midtown–Queens) | 1340 | |
| 3 | ###### | Drinks for a meeting | 2860 | |
| 4 | ###### | Taxi | 4200 | |
| 5 | ###### | Books | 3080 | |
| 6 | ||||
| 7 |
Make the headers dark green with white bold text, add thousands separators to the amounts, fit the column widths, and hide gridlines.
This drill is for computer screens. On a phone you can review the steps.
- Give A1:C1 a dark green fill, white text, and bold
- Apply Comma Style to C2:C5 (Alt → H → K)
- Select the whole table and AutoFit the column widths (Alt → H → O → I)
- View > clear Gridlines (Alt → W → V → G)
Key takeaway
Working in the order data, number formats, widths, then colors and lines means less redoing.
See how to make a table in Excel for details.