Thursday, 27 July 2017

Microsoft Excel 2016 – Navigate worksheets quickly with the Ctrl and directional keys

In Excel you can jump to any of a worksheet’s four edges using the Ctrl and matching arrow key, in the direction of the arrow.

You can also navigate across worksheet tabs using Ctrl + the PgUp or PgDn keys.

Some examples of quick navigation:
If you want to jump to the top of your worksheet, press Ctrl + the arrow key pointing up.

To jump to the bottom, use the down arrow key; to the left, the left arrow key; and to the right, the right arrow key.

To switch between worksheet tabs from left to right, press CTRL+PgUp

To switch between worksheet tabs from right to left, press CTRL+PgDn.

 To see all the various shortcut lists access Help

No comments:

Post a Comment