These selections do not need to be next to one another.
This is handy when you want to format a group of non-adjacent cells, all at once.
To get out of this mode, just press the Escape key or perform an action.
Using this shortcut again will go for the entire worksheet.
These shortcuts work also when multiple cells are selected as.
On Macs without an End key, use Fn + Control + right arrow.
We’ll cover all these options in upcoming videos.