The Basics Of Excel Formatting Shortcuts
Formatting is a common task in Excel. So what are some good formatting shortcuts to increase your speed?
First, memorize these shortcuts for opening up the Format Cells dialog box (shown below):
Format Cells Dialog Box (keyboard): Ctrl+1
Format Cells Dialog Box (hybrid): Right Click+F*
(*Note: this won’t work if you have copied something into the clipboard since at that point “F” will activate the paste Formulas option instead).
You can switch between tabs in the dialog box with your mouse or by typing the first letter for tab (e.g., “F” for Font).
Second, there are some common formats with easy shortcuts:
Bold (keyboard): Ctrl+B –or– Ctrl+2
Italics (keyboard): Ctrl+I –or–Ctrl+3
Underline (keyboard): Ctrl+U –or– Ctrl+4