Shortcuts

Select to last cell downward

Pinterest LinkedIn Tumblr
Select to last cell downward 1

The CTRL + SHIFT + Down arrow key helps to extend the cell selection to the last cell downward. This enables to select to last cell downward.
If there is any break in the data range it stops the selection before the blank cell.
You have to Hold the CTRL + Shift key and tap Down arrow twice or thrice according to the blank cells there in the data range

Select to last cell downward 2

Related Posts

Write A Comment