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

Excel Shortcuts for extending selections

Shortcuts for extending selections

In this video, we'll cover shortcuts for extending selections to include more cells. The most basic way to extend a selection is to use the shift key + any arrow key. From a single cell, this lets you add additional cells in any direction. If you begin with a larger selection, shift will let you …

Support Exceljet

Many websites (including Exceljet) have lost over half their traffic in the past year because of the crushing impact of AI on web searches. Exceljet is still at it, publishing free content each week. If you find Exceljet helpful, you can support the site and go ad-free with the Exceljet Lifetime Pass. One payment, no subscription, and ads are gone forever. Plus, you get our Excel Shortcuts video course as a thank you.

Get the Lifetime Pass

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.