Data Shortcuts

Freebeginner 15 min4 tasks0/66 pts

Ctrl+D fills the formula from the top cell of a selection down, Ctrl+R fills right, and Alt+= inserts an AutoSum for you. Select the cells first, then press the shortcut once and every cell is filled, with references adjusted automatically.

Example: Select D2:D6 where D2 has a formula and press Ctrl+D to copy it to D3:D6.

Common mistakes

Selecting only the empty cells: include the cell that holds the formula.
Alt+= on a single cell shows the formula for you to confirm with Enter.

Cut, Copy, Paste SUM Function