About This Shortcut
Extend the Selection to the Last Cell Down that Contains Data, or to the next cell that contains data, or to the last row- CTRL+SHIFT+ARROW DOWN selects the whole column from the current cell down to the end of the column. This works differently for each column in the same Excel file.
Keybord Shortcut key
- Window: Ctrl + Shift + ↓
- Mac: Cmd + Shift + ↓