Windows Mac
ShiftHome Fn

About This Shortcut 

This shortcut will extend the selection from the active cell to the next cell to the left that is either empty or not empty, depending on the contents of the active cell:

  • If the active cell is empty, the cursor will stop at the next non-empty cell to the left.
  • If the active cell is not empty, the cursor will stop at the next empty cell to the left.
  • Otherwise, the cursor will stop at the start of the row at the left edge of the worksheet.

Related videos

The videos below demonstrate this shortcut.

Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.