Ctrl+F: Display "Find and Replace" Box
The shortcut Ctrl+F is to display the "Find and Replace" dialog box for you to quickly find the information. Same as the shortcut "Shift+F5", the default window is the …
Category: Excel Shortcuts
Ctrl++ (plus): Insert Dialog Box
The shortcut Ctrl++ is to display the Insert dialog box. Step 1: Click any cell in the worksheet; Step 2: Press and hold the Ctrl key, then press the …
Ctrl+]: Formula Refer to Active Cell
The shortcut Ctrl+] (right square bracket) is to select the cells that contain formulas that directly reference the active cell. Please refer to the shortcut Ctrl+Shift+}. Step 1: Click …
Ctrl+[: Cells Referenced by Formula
The shortcut Ctrl+[ (left square bracket) is to select all cells directly referenced by formulas in the selection. Please refer to the shortcut Ctrl+Shift+{. Step 1: Click the cell …
Alt+Shift+F2: Save the Workbook
The shortcut Alt+Shift+F2 is to save the workbook. This is the same as the shortcut "Ctrl+S". Step 1: If you are working on a worksheet, click anywhere in the …
Alt+F2: Display Save As Window
The shortcut Alt+F2 is to display the "Save As" dialog box. Please also refer to Shift+F12. Step 1: Click any cell in the worksheet; Step 2: Press and hold …