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.
I'm not aware of a magic copy-down keyboard shortcut in Excel.
I would hit
- Ctrl+↓ to jump to the bottom of the adjacent range
- Ctrl+Shift+↑ to select the fill range
- then Ctrl+d to fill down.
If you're a keyboard-first user, this is pretty quick even though it's 5 steps.