Ctrl+Apostrophe: Copy a Formula from Cell Above

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 below the cell with a formula;

Step 2: Press and hold the Ctrl key, and press the Apostrophe (') key from the keyboard.

Step 3: Press the Enter key to move the cursor out of the cell.

Check More Excel Shortcuts

Leave a Reply