Format Cells in Excel (Windows)
Press Ctrl + 1 to open the Format Cells dialog.
What it does
The dialog holds every format setting of a cell on its tabs: number format, alignment, font, border, fill and protection. It is the place for formats the ribbon does not show, such as a custom date or number format. The settings apply to all selected cells at once. They change how a value looks and leave the value itself as it is.
The same shortcut on other platforms
| Platform | Shortcut |
|---|---|
| Windowsthis page | Ctrl + 1 |
| macOS |
More Excel shortcuts: Formatting
- Bold
- Italic
- Underline
- Currency Format
- Percentage Format
All 159 Excel shortcuts for WindowsThe full list has a search and a printable PDF.
Questions
What is the Excel shortcut for Format Cells on Windows?
Ctrl+1. Press it to open the Format Cells dialog.
What is the shortcut for Format Cells in Excel on macOS?
On macOS it is ⌘1.