At a lower level, Excel also lets you navigate between cells using shortcuts. The direction keys move the cell selection up, down, left, or right by one cell, when the cell is not selected for value insertion. This can also be achieved using Tab to move right, Shift + Tab to move left, Enter/Return to move down, or Shift + Enter/Return to move up.
Adding the Ctrl key to the direction keys takes it a step further on both Windows and macOS devices, as it becomes possible to move the cell selection to either the left edge of the row (Ctrl + left direction key), the right edge of the row (Ctrl + right direction key), the top of the column (Ctrl + up direction key), or the bottom of the column (Ctrl + down direction key), depending on the initially selected cell.
In addition, there are shortcuts to move by one screen up (PgDn on Windows and Fn + up direction key on macOS), down (PgUp on Windows and Fn + down direction key on macOS), left (Alt + PgUp on Windows and Fn + Option + up direction key on macOS), and right (Alt + PgDn on Windows and Fn + Option + down direction key on macOS).
This set of functions moves all the currently displayed cells in the direction of the shortcut command. Other cell navigation shortcuts include selecting the first or last cells in a range of data, using Ctrl + Home or Ctrl + End on Windows and Fn + Control + left direction or right direction on macOS, respectively.
For all the latest Games News Click Here
For the latest news and updates, follow us on Google News.
