Navigating Worksheets in Excel – Instructions

Navigating Worksheets in Excel: Video Lesson

            This video lesson, titled “Navigating Worksheets,” shows you different ways of navigating worksheets in Excel. This video lesson is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.”

Navigating Worksheets in Excel: Overview

            Navigating worksheets in Excel lets you view different worksheets in a workbook. To move from one worksheet to another, click the worksheet name tab of the worksheet to view. The worksheet name tabs appear in the lower-left corner of the workbook.

            You can also use keyboard shortcuts to navigate worksheets in Excel. Pressing “Ctrl” + “PageUp” moves to the previous worksheet. Pressing “Ctrl” + “PageDown” moves to the next worksheet.

            If you have many worksheets in a workbook or give worksheets very long names, you may not be able to see all the worksheet name tabs. This is because they begin to slide underneath the horizontal scroll bar to the right. Only when this occurs can you then click the “Previous Sheet” and “Next Sheet” buttons to the left of the worksheet name tabs. Doing this then moves the worksheet tab names out from underneath the horizontal scroll bar. Keep clicking until you see the one you want to view. At that point, then click its worksheet name tab to view it.

            Alternatively, you can also right-click either the “Previous Sheet” or “Next Sheet” buttons. Then select the name of the worksheet to view in the “Activate” dialog box that appears. After selecting the sheet name to view, click the “OK” button to activate the selected worksheet.

Navigating Worksheets in Excel – Instructions: A picture of a user navigating worksheets in Excel by using the “Activate” dialog box.

Navigating Worksheets in Excel: Instructions

1. To move from one worksheet to another in Excel, click the worksheet name tab of the worksheet to view from the set of worksheet name tabs in the lower-left corner of the workbook.
2. Alternatively, to move to the previous worksheet using a keyboard shortcut, press “Ctrl” + “PageUp” on your keyboard.
3. Alternatively, to move to the next worksheet using a keyboard shortcut, press “Ctrl” + “PageDown” on your keyboard.
4. Only after you have worksheet name tabs that have slid underneath the horizontal scroll bar can you then click the “Previous Sheet” and “Next Sheet” buttons to the left of the worksheet name tabs to move the names of the worksheet tabs out from underneath the horizontal scroll bar until you can see the one you want to view.
5. At that point, then click its worksheet name tab to view it.
6. Alternatively, right-click either the “Previous Sheet” or “Next Sheet” buttons to select the name of the worksheet to view from the “Activate” dialog box that appears.
7. After selecting the sheet name to view, then click the “OK” button to activate the selected worksheet.