In the following Excel spreadsheet, I'm active in cell C2 and want to copy the formula down to C11. How can I achieve that with the keyboard? Most answers seem to begin with "highlight the range you need", but doing Ctrl+Shift+Down takes me down to the end of the spreadsheet. However, if I double click the drag handle in the corner of the cell, it deduces the range correctly.

Link to picture


I'm not aware of a magic copy-down keyboard shortcut in Excel.

I would hit

  1. Ctrl+ to jump to the bottom of the adjacent range
  2. Ctrl+Shift+ to select the fill range
  3. then Ctrl+d to fill down.

If you're a keyboard-first user, this is pretty quick even though it's 5 steps.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.