Format cells, numbers and dates

Updated November 13, 2026

Quick formatting

Select cells, then use Home:

  • Font: the font and size boxes, Bold (Ctrl+B), Italic (Ctrl+I), Underline (Ctrl+U), Fill and Font color.
  • Borders: pick a border from the Borders list.
  • Alignment: Left, Center, Right, Wrap text, and Merge or Merge options.
  • Numbers: the number format box, Currency, Percent, Comma, and More or Fewer decimal places.
  • Cell styles: ready-made looks for headings, totals and good, bad or neutral values.
  • Format painter: copy one cell’s formatting to others.

Everything in one place

  1. Select cells and choose Home › Format…, or Format › Format Cells… (Ctrl+1).
  2. Use the tabs: Number, Alignment, Font, Border, Fill and Protection.
  3. Choose OK.

On the Number tab you can pick a category such as Currency, Date or Percentage, or write your own format code, such as #,##0.00 or d mmm yyyy.

Number format shortcuts

Keys Format
Ctrl+Shift+~ General
Ctrl+Shift+! Number with two decimals and a thousands separator
Ctrl+Shift+$ Currency
Ctrl+Shift+% Percentage
Ctrl+Shift+^ Scientific
Ctrl+Shift+# Date
Ctrl+Shift+@ Time

If something goes wrong

  • A cell shows ######. The column is too narrow for the number or date. Widen it, or double-click the line on the right of its column header.

Was this article helpful?