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 extend the edges of that selection.
This works with entire rows and columns, too.
If I select a row, I can use shift to select additional rows above or below.
By adding the shift key too, you could select data in the same way.
I can also do the same thing starting from the bottom.
Extending first to the top, then extending back to the left.
you’ve got the option to also use the shift key to extend selections screen-by-screen.
And on Macs without extended keyboards use Shift + Fn + Command with the up or down arrow keys.
But note that this selects the headers too, unless you’re inside a proper Excel table.
We’ll cover shortcuts for working with tables in a separate video.
