The format of the cells plays a huge role in Excel.
You can format data in different ways (such as show dates in different formats or add/remove decimals or thousand separators, or change the alignment/borders of the cells).
Excel has a Format Cells dialog box that gives you all the formatting options in one place.
In this tutorial, I will give you the shortcut to open the Format Cells Options dialog box in Excel.
Shortcut to Open Format Cells Dialog Box in Excel
Below is the shortcut to Format Cells Options in Excel:
Control + 1
How to Use the Keyboard Shortcut to Format Cells Options in Excel
Below are the steps to use the above keyboard shortcut:
- Select the cell or range of cells for which you want to change the format
- Hold the Control key and then press the 1 key
The above steps would open the Format Cells dialog box where you can make format changes using the options under different tabs, and once done, click the Ok button.
Important Things to Know About Format Cells Options in Excel:
- Any changes that you make through the Format Cells dialog box will only change the formatting of the selected cells. It would not change the actual values in the cells.
- There are some options in the Format Cells dialog box that you may not find anywhere else in Excel, such as the custom number formatting option, Shrink to Fit or Strikethrough formatting option, or using the Subscript or Superscript formatting option, etc.
Alternate Ways to Format Cells Options in Excel:
The Format Cells dialog box can also be opened through the ribbon in Excel.
Below are the steps to open the Format Cells dialog box without the shortcut:
- Click the Home tab
- Click on the dialog box launcher icon (the small tilted arrow icon) in the Home, Alignment, or Number group.
Other Excel shortcuts you may also like:
- Excel Keyboard Shortcuts
- Shortcut to Fill Color in Excel
- Apply Border to Cells in Excel
- Edit Cell in Excel
- Merge or Unmerge Cells in Excel
- Format Painter in Excel (Shortcut)
Other Excel Tutorials You May Also Like:
