Skip to content

Module 02 · Lesson 05

Format like a professional

Seven steps from plain grid to finished table.

Excel tools6 min
  1. 1

    Title. Merge & Center over the table, bold, bigger, coloured fill.

  2. 2

    Header. Bold, dark fill, white text, centred, Wrap Text.

  3. 3

    Borders. Select the table › Ctrl+1 › Border › Outline + Inside.

  4. 4

    Numbers. Ctrl+1 › Number: 2 decimals, thousands separator.

  5. 5

    Widths. Alt, H, O, I autofits columns to the text.

  6. 6

    Freeze. Alt, W, F, F keeps the header visible while scrolling.

  7. 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)