Excel Format Cells Shortcut: Open the Dialog in Seconds

In Excel for Windows, select a cell or range and press Ctrl+1 to open the Format Cells dialog box. On a Mac, use Command+1. From the dialog, choose a tab to change number formats, alignment, fonts, borders, fills, or protection settings.

Shortcut at a glance

The shortcut opens a settings window; it does not apply a particular format by itself. After the dialog appears, choose the setting you want, confirm it, and Excel applies the change to the selected cells. The same shortcut is useful whether you are changing one cell or a selected block of a worksheet.

Windows: Ctrl+1
Mac: Command+1
Excel for the web: Keyboard behavior can depend on the browser and the web app’s shortcut handling. If the key combination is intercepted or does not open the dialog, use the formatting controls on the Home tab.

Press the number 1 key while holding the modifier key. If you are editing text inside a cell, first press Enter to finish the edit or Esc to cancel it; Excel’s normal worksheet shortcuts are not available in the same way while the insertion point is active inside a cell.

What the Format Cells dialog contains

Format Cells groups common cell appearance and display settings into six tabs. The labels are consistent in desktop Excel, although the options shown within a tab vary according to the selected cells and the active format category.

Number: Sets categories such as General, Number, Currency, Accounting, Date, Time, Percentage, Fraction, Scientific, Text, and Custom. Many categories also let you choose decimal places, symbols, or negative-number styles.
Alignment: Controls horizontal and vertical alignment, text orientation, wrapping, indentation, and whether selected cells are merged.
Font: Changes typeface, style, size, underline, color, and other text effects.
Border: Applies lines to selected cell edges and lets you choose line styles and colors.
Fill: Sets a cell’s background color and, where available, fill effects.
Protection: Sets the Locked and Hidden properties of cells. Those properties take effect for sheet protection only after the worksheet is protected.

This makes the dialog a central place for formatting, but not a universal editing window. It does not change a cell’s formula, rewrite the value, or determine whether a conditional-formatting rule will apply. Those are separate worksheet features.

Open it and apply a change

For a straightforward formatting change, the process is short. If your goal is to change several cells consistently, select the entire target range before opening the dialog so the change is applied in one pass.

Select the cell or range. To select a full column or row, click its heading; make sure the selection is the area you intend to format.
Press Ctrl+1 on Windows or Command+1 on Mac.
Choose the relevant tab and set the options. For example, on Number, choose Percentage and adjust decimal places if needed.
Review the sample or preview when one is shown, then choose OK to apply the settings.

For example, suppose a column contains values such as 0.25 and 0.5 that represent proportions. Select the cells, open Format Cells, choose Percentage, and set the desired decimal places. Excel will display those values as percentages, such as 25% and 50%, while retaining their numeric values for calculations. The exact display depends on the decimal-place setting.

If you want to leave without applying a change, choose Cancel. A dialog can show a preview of the selected formatting, but that preview does not mean the worksheet has already been changed; the change is committed when you confirm it.

Selection determines what gets formatted

Format Cells works on the active selection. If one cell is selected, the setting affects that cell. If a rectangular range is selected, it affects the selected cells. When a selection contains cells with different existing formats, the dialog may show a blank or mixed state for some settings; that is a sign that the selection does not have one uniform value for that option.

Take care with whole-row and whole-column selections. Choosing a number format for an entire column can be convenient when new entries will be added there later, but changing alignment or fill for a whole worksheet column may also affect cells far below the data. For a table that may grow, formatting the relevant table column or a planned input range is often more controlled.

Formatting also does not always repair the underlying data. Applying a date format to a number can change how Excel displays that number, but applying a date format to text that Excel has stored as text does not necessarily convert that text into a real date value. Likewise, choosing Currency changes a numeric value’s display, not the value itself. Check the formula bar or use a calculation if you need to verify what the cell contains.

Choose the right format for the job

The Number tab is often the reason people open this dialog. Its categories can make a worksheet easier to read without changing the underlying numeric value. The best choice depends on what the data represents and how precise the display needs to be.

Number: Useful for counts or measurements when decimal places and a thousands separator matter.
Currency or Accounting: Appropriate for monetary values. Accounting formatting aligns currency symbols and decimal points across a column; Currency places the symbol closer to the value.
Percentage: Displays a decimal proportion as a percentage. A stored value of 0.25 displays as 25% when formatted as a percentage with no decimal places.
Date or Time: Changes the display of a valid Excel date or time value. Pick a layout that readers can interpret unambiguously.
Text: Displays cell contents as text, but changing a cell to Text after a number has already been entered does not by itself convert that existing number into text.
Custom: Lets you build a display pattern for values, such as showing leading zeros. It changes presentation, not the stored value.

A frequent misconception is that a number format changes the value used in formulas. In normal cases, it changes only the display. A cell containing 0.25 remains 0.25 when shown as 25%, so a formula that uses that cell still works with the underlying value. If the value itself must change, use an appropriate data-entry or calculation method instead of relying on formatting.

Other ways to open the dialog

The keyboard shortcut is usually quickest, but it is not the only route. On Windows desktop Excel, right-click a selected cell and choose Format Cells from the context menu. You can also go to the Home tab and click the small dialog box launcher at the lower-right of the Number group. That launcher opens the Format Cells dialog with the Number tab selected.

Ribbon controls are handy when you are already working with the mouse or need to find a command visually. The Home tab also offers quick controls for common changes, including number formats, font, fill, borders, and alignment. Those controls can apply a change directly, whereas Ctrl+1 opens the broader dialog so you can review several settings together.

Some Excel keyboard references also list Ctrl+Shift+F as a way to open Format Cells with the Font tab selected in Windows desktop Excel. Ctrl+1 remains the general shortcut to remember because it opens the dialog without requiring you to know which tab you will need. If a shortcut behaves differently on a particular keyboard or installation, use the context menu or the Number group launcher instead.

Windows, Mac, and Excel for the web

This page focuses on Excel for Microsoft 365 on Windows. On Mac, the corresponding dialog shortcut is Command+1 rather than Ctrl+1. Mac keyboards and system settings can affect how modifier keys feel, but the command to open the dialog uses Command. If you use Excel regularly on both platforms, remember the different modifier rather than assuming Windows and Mac shortcuts are identical.

Excel for the web runs inside a browser, so some keyboard combinations may be handled by the browser or may vary with the app’s current shortcut support. If Ctrl+1 does not open the formatting options in your web session, select the range and use the controls on the Home tab. The web interface may present formatting options in a pane or menu rather than in the same desktop-style dialog. Avoid treating a browser tab shortcut as an Excel formatting command.

Features can also differ between desktop and web editions. If a particular format option is not available in the web interface, opening the workbook in the desktop app may provide the full set of desktop dialog controls. The workbook’s formatting remains part of the file, but the route for changing it can depend on the app.

Common problems and fixes

If Ctrl+1 appears to do nothing, first check that Excel has focus and that you are not currently editing a cell. Press Enter or Esc to return to normal worksheet mode, then try again. Also check whether another application, keyboard utility, or remote-desktop setup is capturing the shortcut.

If the dialog opens but a setting is unavailable, worksheet protection may be the reason. A protected worksheet can restrict formatting according to the permissions chosen when protection was enabled. The sheet’s owner may need to unprotect it or change the allowed actions; do not assume the shortcut itself is broken.

If a displayed value seems wrong after formatting, inspect the underlying value before changing the format again. A date displayed as a large number may be a valid date serial shown with General formatting. A value that stays unchanged after choosing Date may instead be text. A percentage that looks 100 times too large may have been entered as a whole number rather than a decimal proportion. Formatting changes appearance; it does not automatically infer or correct the intended data.

Finally, remember that manually applied formatting and conditional formatting are different. A fill color set through Format Cells is a direct cell format. A conditional-formatting rule can change the appearance when its condition is met and may override what you expect to see. To inspect those rules, use Home > Conditional Formatting > Manage Rules, rather than looking only in Format Cells.

Frequently Asked Questions

What is the shortcut to open Format Cells in Excel?
Press Ctrl+1 in Excel for Windows. On a Mac, press Command+1. The dialog opens for the currently selected cell or range.

Does Ctrl+1 apply a number format?
No. It opens the Format Cells dialog. You must choose a category or setting and confirm it to apply a change. For a quick number format, use the number-format controls on the Home tab.

Can I open Format Cells without a keyboard shortcut?
Yes. Right-click the selection and choose Format Cells, or use the dialog box launcher in the Number group on the Home tab in desktop Excel for Windows.

Why does Ctrl+1 not work in Excel for the web?
The browser or web app may handle the shortcut differently, or Excel may not have focus. Use the Home tab’s formatting controls if the shortcut is intercepted or unavailable in your session.

Will changing a cell’s format change its value?
Usually not. A number format changes how a value is displayed, while formulas continue to use the underlying value. It also does not reliably convert text into a number or date just by choosing a different display format.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.