Press CTRL+an arrow key to scroll to the start and end of each range in a column or row before stopping at the end of the worksheet. To scroll to the start and end of each range while selecting the ranges before stopping at the end of the worksheet, press CTRL+SHIFT+an arrow key.
What does CTRL-arrow key do?
When you press Ctrl and any arrow key (north, east, south, or west), you jump to the last populated cell in that direction. Think of using the Ctrl-arrow key shortcut as an alternative to pressing Page Down to find the bottom row of a data set or pressing Tab to find the last column.
What does pressing CTRL Shift Right Arrow do in Excel?
SHIFT+arrow key Extend the selection by one cell. CTRL+SHIFT+arrow key Extend the selection to the last nonblank cell in the same column or row as the active cell.