Excel Shortcuts

Back to Excel Shortcuts

Excel Shortcut: Extend the Selection to the Last Cell Down

Umesh Manral March 1, 2023 Excel Shortcuts

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 + ↓

Example:

Back to Excel Shortcuts

Share
Umesh Manral

Automation Specialist & Consultant

Umesh Manral

I'm a passionate Excel expert with a decade of experience transforming complex data into actionable insights. My journey began when I discovered the power of Excel macros to automate tedious tasks during…

View author profile