What is format cell options in Excel ?
When we format cells in Excel, we change the appearance of a number without changing the number itself. We can apply a number format (0.8, $0.80, 80%, etc) or other formatting (alignment, font, border, etc). This tutorial will teach you keyboard shortcut to open the format cell options in Microsoft Excel.
Tutorial in Brief
To open the format cells option in Excel, you need to select a cell or a range of cells and then press the following keyboard shortcut:
Control + 1
When you press this shortcut key, it instantly opens the format cells option which gives you the following dialog box.
How to use it ?
- First of all, select a cell or range of cells where you want to use the format cells options.
- After that, press and hold the Control key from the from the left side of the keyboard.
- Next, press the 1 key from the top of the keyboard.
- In the end, select the tab from the options.
