Category: Excel Shortcuts

The shortcut Shift+F3 is to display the "Insert Function" dialog box. Step 1: Click any cell in the worksheet; Step 2: Press and hold the Shift key, then press …

The key F4 is to repeat the last command or action, or cycles through all combinations of absolute and relative references in a formula. Step 1: Highlight the cell …

The shortcut Ctrl+E is to automatically recognize the pattern and "Flash Fill" the current column. Flash fill is a new feature since Excel 2016. It is super useful when …

The shortcut Ctrl+Shift+A is to finish a function by inserting the argument names and parentheses. Step 1: Click the cell you want to insert argument; Step 2: Type the …

The shortcut Alt+Shift+F10 is to display the menu for an error checking button. Step 1: Click any cell in the data range; Step 2: Press and hold the Alt …

The shortcut Ctrl+Alt+Shift+F9 is to check dependent formulas, then calculate all cells in all open workbooks (see how to set Calculation Option to Manual). Step 1: Click the cell, …