Category: Excel Shortcuts

The shortcut Ctrl+Back Slash (\) is to select the cells that don't match the formula or static values. Step 1: Select the cells in the worksheet; Step 2: Press …

The shortcut Ctrl+Shift+Vertical Bar (|) is to select the cells that don't match the formula or static values in the active cells. Step 1: Select the cells in the …

The shortcut Ctrl+Shift+} (right curly bracket) is to select cells that contain formulas that reference the active cell. Please refer to the shortcut Ctrl+]. Step 1: Click any cell in …

The shortcut Ctrl+Shift+{ (left curly bracket) is to select all cells directly referenced by formulas in the selection. Please refer to the shortcut Ctrl+[. Step 1: Click the cell with …

The shortcut Ctrl+Shift+( (right parenthesis) is to unhide the selected rows. Check "Ctrl+9" to see how to hide rows. Step 1: Select the row that are hidden; Step 2: …

The shortcut Ctrl+P is to display the Print dialog box, please also refer to the shortcut Ctrl+F2. Step 1: Click anywhere in the worksheet; Step 2: Click and hold …