Category: Excel Shortcuts

The shortcut Ctrl+Apostrophe (') is to copy a formula from the cell above into the active cell or the Formula Bar. Step 1: Move the cursor to the cell …

The shortcut Ctrl+Alt+V is to paste content by using the Paste Special dialog box. Step 1: Copy the content or data range; Step 2: Click the place where you …

The shortcut Ctrl+9 is to hide the selected rows. Please check "Ctrl+Shift+(" to see how to unhide rows. Step 1: Click any cell in the worksheet (e.g., A1); Step …

The shortcut Ctrl+6 is to switch between hiding and displaying objects. Step 1: Click anywhere in the worksheet; Step 2: Press and hold the Ctrl key, then press number …

The shortcut Ctrl+5 is to apply or remove strike through formatting. Step 1: Select the data range you want to italicize (e.g., B2:D4); Step 2: Press and hold the …

The shortcut Ctrl+4 is to underline text or remove underline, same as shortcut Ctrl+U. Step 1: Select the data range you want to underline (e.g., B2:D4); Step 2: Press …