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
- Select cells and choose Home › Format…, or Format › Format Cells… (Ctrl+1).
- Use the tabs: Number, Alignment, Font, Border, Fill and Protection.
- 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.