Templates Services SQL Reports Excel Shortcuts Blog About Contact
⌨ Excel Shortcut Guide

Format cells dialog Shortcut in Excel

Use this quick reference to learn the Windows shortcut, Mac shortcut, Ribbon path, and best use case for format cells dialog in Excel.

Shortcut keys

WindowsCtrl + 1
MacCmd + 1

Ribbon path

Home → Format → Format Cells

What it does

Opens the full Format Cells dialog with tabs for Number, Alignment, Font, Border, Fill, and Protection.

How to use this shortcut

  1. Open the Excel workbook and select the relevant cell, row, column, range, or sheet.
  2. Press the shortcut keys shown above for your platform.
  3. Confirm any dialog options if Excel opens a menu or prompt.

FAQ

What is the Excel shortcut for format cells dialog?

On Windows, use Ctrl + 1. On Mac, use Cmd + 1.

Where is format cells dialog in the Excel Ribbon?

The Ribbon path is Home → Format → Format Cells.

What does format cells dialog do in Excel?

Opens the full Format Cells dialog with tabs for Number, Alignment, Font, Border, Fill, and Protection.