Excel - How to use the Navigation pane for charts, tables, PivotTables, pictures, and worksheets
Posted on: 10/31/2021
The Navigation pane in Excel is an easy way to understand a workbook's layout. With the Navigation pane, you can see charts, tables, images, and PivotTables. The Navigation Pane even shows you the elements by worksheet.

Navigation Pane in Excel - Worksheets show and elements on the worksheet
Clicking an element will take you directly to that element. The Navigation pane appears on the right side of your Excel file. It can be resized. To open the Navigation pane, have Excel open and click the View tab - Navigation pane, and it will open on the right side.
YouTube video
Open the Navigation Pane
-
Click the View Tab.
-
Click Navigation.

Navigation Pane in Excel
Explore the elements
When the Navigation pane opens, you'll see a list of elements such as tables, named ranges, and other elements from this sheet. Each sheet within the workbook will be in its own section. Select a section to expand and display its contents.
Each section will show any tables, charts, PivotTables, and images located on the sheet. Selecting an element will move the focus to that element on the sheet.
If the element is on another sheet within the workbook, the focus will switch to the correct sheet and element.

Elements in the Navigation Pane
Other Excel articles
Artificial Intelligence (AI) in Microsoft 365
Artificial Intelligence (AI) is in all Microsoft 365 apps - Excel, Word, Outlook, PowerPoint, Teams, and other M365 apps. In Excel, we have Analyze data on the Home tab and the ability to get data from a picture or screenshot.
Chris Menard
Chris Menard is a Microsoft Certified Trainer (MCT) and is employed full-time as a Trainer for BakerHostetler, one of the nation’s largest law firms. Menard has a YouTube channel with over 900 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 16 million viewers have appreciated. Menard also does public speaking at conferences for CPAs and Administrative Professionals. Connect with Chris on LinkedIn at chrismenardtraining.com/linked or on YouTube at chrismenardtraining.com/youtube
Categories