Module 02 · Lesson 05
Format like a professional
Seven steps from plain grid to finished table.
Excel tools6 min
- 1
Title. Merge & Center over the table, bold, bigger, coloured fill.
- 2
Header. Bold, dark fill, white text, centred, Wrap Text.
- 3
Borders. Select the table › Ctrl+1 › Border › Outline + Inside.
- 4
Numbers. Ctrl+1 › Number: 2 decimals, thousands separator.
- 5
Widths. Alt, H, O, I autofits columns to the text.
- 6
Freeze. Alt, W, F, F keeps the header visible while scrolling.
- 7
Filter. Ctrl+Shift+L adds sort/filter arrows.
Formatting shortcuts
- Ctrl1
- Format Cells box: everything in one place
- CtrlB
- Bold (Ctrl+I italic, Ctrl+U underline)
- CtrlShift!
- Number with 2 decimals and commas
- CtrlShift$
- Currency format
- CtrlShift%
- Percentage format
- CtrlShift&
- Outline border around the selection
- CtrlShift+
- Insert row/column (Ctrl+- deletes)
- CtrlShiftV
- Paste values only (Excel 365)