islamger.blogg.se - How to show hotkeys in excel

In order to move to a different space of your workbook using the Go To command, follow these steps: You will especially appreciate this method if you have to deal with overloaded Excel documents with lots of rows and columns on a daily basis. Using the Go To command is another handy way of moving around your Excel worksheet. For example, it will save you time while navigating Excel, or doing such routine tasks like changing row height and column width in the program. Learning a few more essential shortcuts can help improve your productivity. That’s just one example of a useful keyboard shortcut for Excel.

To keep moving to the left, press the PgUp key again.

In order to move back or one sheet to the left, hold down Ctrl, then press the PgUp key.

To keep moving to the right, press the PgDn key again.

In order to move one sheet to the right, hold down Ctrl, then press the PgDn key.

Or simply follow these steps to switch between sheets in the workbook:

There are two shortcuts that you’ll need to learn here: Ctrl + PgDn (page down) for moving to the sheet on the right, and Ctrl + PgUp (page up) for moving to the sheet on the left.