In Excel for Microsoft 365 on Windows, press Ctrl+1 to open the Format Cells dialog for the selected cell or range. On a Mac, press Command+1. From the dialog you can change number formats, alignment, fonts, borders, fills, and protection settings without hunting through the ribbon.
The shortcut and what it opens
The Format Cells shortcut is useful because it brings several kinds of cell appearance and behavior together in one window. Select one cell or a group of cells, then press Ctrl+1 on Windows. The dialog opens with tabs for Number, Alignment, Font, Border, Fill, and Protection. The selected range determines which cells the settings will affect; the shortcut does not change the cell’s contents by itself.
For example, select a column of prices and press Ctrl+1 to choose Currency or Accounting formatting. Select a long text column to set wrapping or alignment, or select a table range to add borders. Make a choice, check the sample or preview where available, and choose OK to apply it. Choose Cancel, or press Esc, to close without applying your pending changes.
This is a dialog shortcut, not a command to apply one particular format. Ctrl+1 does not automatically turn a value into currency, bold text, or add a border. It opens the settings so you can decide what to apply.
How to use it step by step
- Select the cell, cells, row, or column you want to format. For nonadjacent cells, hold Ctrl while selecting additional ranges on Windows.
- Press Ctrl+1. On a Mac, use Command+1.
- Choose the relevant tab, such as Number for dates and decimals or Alignment for wrapping and orientation.
- Adjust the options, then choose OK. To leave the cells unchanged, dismiss the dialog with Cancel.
You can select cells using the mouse or the keyboard. For instance, click the first cell, hold Shift, and click the last cell in a continuous range. You can also use Shift with the arrow keys to extend a selection. If you select a whole column or row using its heading, the chosen format applies to cells throughout that column or row, including cells you fill later.
If the dialog does not appear, first make sure Excel itself has focus rather than a text field, search box, or another application. Keyboard shortcuts can be intercepted by browser extensions, remote-desktop software, or operating-system utilities. On a laptop, use the number-row key 1 with Ctrl; the shortcut is not Ctrl+F1.
What the Format Cells tabs control
- Number: Choose categories such as General, Number, Currency, Accounting, Date, Time, Percentage, Fraction, Scientific, Text, or Special. Available choices and previews depend on the selected cells and regional settings.
- Alignment: Set horizontal or vertical alignment, indentation, text orientation, wrapping, and whether to merge selected cells. Wrapping is useful for headings that should stay within a column rather than spill into the next empty cell.
- Font: Change the typeface, style, size, underline, and font color. The Home tab also exposes common font controls directly.
- Border: Choose border positions, line styles, and colors. This lets you apply, for example, only a bottom border beneath a total row rather than outlining every cell.
- Fill: Set a cell background color or pattern. A fill is a static appearance choice; it is different from Conditional Formatting, which changes appearance when rules are met.
- Protection: Mark cells as locked or hidden. These settings take effect when the worksheet is protected; changing the Locked checkbox alone does not prevent editing.
These tabs make the dialog a handy place for less frequent settings, while the Home ribbon is often faster for everyday font, fill, and alignment changes. If you need a specific number display, Number is usually the right starting point. If the content is technically correct but looks crowded, try Alignment before changing the column width or deleting text.
Number formats and what they do
A number format controls how Excel displays a value, not necessarily the value stored in the cell. A cell containing 0.25 can display as 25% when formatted as Percentage, and the underlying value remains 0.25. Likewise, a date is generally stored as a serial number and displayed using a date format. Changing the display does not normally recalculate or rewrite the underlying number.
Use the Number tab when a value should be easier to read or presented consistently. For example, choose Number and set decimal places to show a consistent number of digits. Choose Date to select a date display, or Percentage to show a ratio as a percent. With a percentage format, Excel displays 0.25 as 25%; it does not convert the stored value to 25.
The Custom category lets you define display patterns when the built-in categories are not suitable. A format such as 00000 displays the number 123 as 00123, which can be useful for codes that need leading zeroes. It does not turn the number into text, however, so codes that must preserve exact characters or exceed numeric limits may be better stored as text. A custom format such as 0.00 displays two decimal places, while the stored value can retain more precision.
Dates deserve a little care: the same date can appear differently depending on the selected format and regional settings. If a date appears as a number, it may simply have a General or numeric format. If changing the format does not make it display as a date, the entry may have been stored as text rather than as an Excel date value.
Quick formats that do not require the dialog
Ctrl+1 is best when you want to inspect or customize several settings. For common number formats, Excel also has direct keyboard shortcuts on Windows. Select the cells first, then use the applicable combination:
- Ctrl+Shift+~: Apply the General number format.
- Ctrl+Shift+!: Apply Number format with two decimal places and a thousands separator.
- Ctrl+Shift+$: Apply Currency format with two decimal places.
- Ctrl+Shift+%: Apply Percentage format with no decimal places.
- Ctrl+Shift+#: Apply a date format.
- Ctrl+Shift+@: Apply a time format.
- Ctrl+Shift+^: Apply Scientific format.
These shortcuts apply a preset; they do not open Format Cells. The exact display can depend on Excel’s regional settings, and a preset may not match the number of decimal places or currency symbol you need. Use Ctrl+1 afterward to fine-tune a preset or choose a different category. On Mac, some key combinations differ, and keyboard layouts affect which characters are available; Command+1 remains the direct way to open the dialog.
Formatting is not the same as changing data
A common misconception is that a cell’s displayed appearance is the same thing as its stored content. Formatting can make 0.5 look like 50%, but it does not change the value to 50. Similarly, applying a date format to a text string does not necessarily convert that string into a date. This distinction matters in calculations, sorting, filtering, and data imports: a value that looks right on screen may still be stored in a form Excel cannot use as intended.
Formatting also does not remove extra decimal precision. If a value is 1.236 and the cell is set to display two decimal places, it appears as 1.24, but calculations can still use 1.236. If a calculation must actually round, use a suitable rounding formula in the worksheet rather than relying on the display format alone.
One more distinction: ordinary formatting is separate from Conditional Formatting. A fill color set in Format Cells remains until changed, whereas a conditional-format rule applies formatting when its condition is true. For values that should be highlighted only when they meet a criterion, use the Conditional Formatting commands rather than manually filling cells.
Common problems and practical fixes
- The shortcut seems to do nothing: Confirm Excel has focus and that you are not editing a cell. Press Enter or Esc to finish editing, then try Ctrl+1 again. On a Mac, try Command+1.
- Numbers show as ####: The column may be too narrow to display the formatted value. Widen the column or choose a shorter display format; the hashes usually do not mean the value has disappeared.
- A date format does not change the display: Check whether the cell contains a real date value or text that resembles a date. Formatting changes appearance, but cannot reliably convert every text entry into a date.
- Leading zeroes disappear: Excel may interpret an entry such as a code as a number. A custom format can display zeroes for a numeric value, but if the code is an identifier whose characters matter, store it as text when entering or importing it.
- A format appears to affect more cells than expected: Review the selection before opening the dialog. If the selection includes a whole column, the change applies to the whole column, not only the visible cells.
- Locked cells are still editable: The Locked setting in Format Cells only matters after worksheet protection is enabled. Review the sheet-protection controls separately, and remember that protection is intended to restrict editing, not to encrypt or secure sensitive workbook data.
Windows, Mac, and Excel for the web
This page focuses on Excel for Microsoft 365 on Windows, where Ctrl+1 opens Format Cells. In Excel for Microsoft 365 for Mac, use Command+1. Mac keyboards and system shortcuts can vary, so if the key combination is intercepted, locate the formatting controls on the ribbon instead.
Excel for the web runs in a browser and may have a different interface or shortcut behavior depending on the browser and keyboard. If Ctrl+1 is captured by the browser or does not open the expected controls, select the cells and use the Home tab’s number-format and cell-format controls. The web version does not always expose the same full set of desktop dialog options. For a particular feature that is unavailable in the browser, open the workbook in the desktop app.
In desktop Excel, the Format Cells dialog is especially helpful for settings not always visible at a glance on the ribbon, including detailed custom number patterns and border combinations. Conversely, for simple tasks such as bolding a heading or choosing a common number format, the Home tab can avoid an extra dialog step.
Frequently Asked Questions
What is the Excel Format Cells shortcut?
In Excel for Microsoft 365 on Windows, press Ctrl+1. On a Mac, press Command+1. Select the cells first so the dialog applies to the intended range.
Does Ctrl+1 format a cell automatically?
No. It opens the Format Cells dialog. Choose the format or setting you want and confirm it; the shortcut itself does not apply a preset format.
How do I open Format Cells without a keyboard shortcut?
Right-click the selected cells and choose Format Cells from the context menu, or use the relevant formatting controls on the Home tab. The available controls can differ between desktop Excel and Excel for the web.
Can I use Ctrl+1 to add leading zeroes?
Yes. Select the cells, open the Number tab, choose Custom, and use a pattern such as 00000 for a five-digit display. This changes how a number looks; for identifiers that must be preserved as text, use a text representation instead.
Why does a formatted number still calculate with extra decimals?
Number formatting changes the displayed precision, not the stored value. A cell can show 1.24 while calculations still use 1.236. Use a rounding calculation if the value itself must be rounded.
Related
- Excel Dependent Drop-Down Lists in Tables
- Excel Dependent Drop-Down List: 3 Levels
- Excel Date Number to Text: Convert Dates Clearly
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Add Leading Zeros in Excel 365: Text or Number?To add leading zeros in Excel 365, select the cells and use a custom number format such as…
- How to Mail Merge in Word 365: A Step-by-Step GuideTo mail merge in Word 365, create or open a recipient list, choose a merge type from the…
- Google Sheets Conditional Formatting If True: How It WorksYes. In Google Sheets, conditional formatting applies a style when a cell meets a selected condition; for more…
- Advanced Excel Power Query: Techniques and WorkflowsAdvanced Excel Power Query is the practice of building repeatable, well-organized data import and transformation workflows in Excel,…
- Data Validation in Excel: Lists, Rules, and FixesIn Excel for Microsoft 365 on Windows, open the Data tab, select the cells to control, then choose…
- Excel: How to Hide Column Lines and Gridlines on a WorksheetTo hide the faint lines between columns and rows in Excel for Microsoft 365 on Windows, open the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.