About This Shortcut

Extends the selection to the cell at the intersection of the last column (to the right) that contains data and the last row that contains data. The last cell in a worksheet may or may not contain data.

About This Shortcut

With extend selection enabled, you don’t need to press Shift to extend the current selection.