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.

pic1

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.

pic2

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.

pic3

Advertisements
This entry was posted in Office. Bookmark the permalink.