Navigating Excel Worksheets

In case you have forgotten a couple Excel terms…the file is called a workbook and each sheet is called a worksheet.

Once you start storing a lot of data in Excel, you may have workbooks with many worksheets like the example below.


Navigating all of these worksheets isn’t always fun using the four navigation buttons. These help you go to the beginning, the end, left one sheet or right one sheet.


You can also cycle through them using your keyboard. [Ctrl]+[PgUp] and [Ctrl]+[PgDn] will move left and right through all of your worksheets.

But did you know that you can go directly to a worksheet without scrolling? Right click on any one of the four navigation buttons and you will get a pop-up menu that lists all of your work sheets. Select the worksheet you want to use and left click.


This entry was posted in Office. Bookmark the permalink.