Excel for Microsoft 365 Excel for Microsoft 365 for Mac More...Less
The Navigation pane in Excelis an easy way to understand a workbook's layout, see what elements exist within the workbook,and navigate directly to those elements. Whether you're a new user getting familiar with Excel, or an experienced user trying to navigate a large workbook, the Navigation panecan help.
Find and accesselements such as tables, charts, PivotTables, and imageswithin your workbook. Once you've opened the Navigation pane, it displays on the right side of the Excel window.
The Navigation pane also makes it easier for those with visual impairments to access all parts of the workbook. It can improve how tools such as screen readers interpretyour workbook.
Open the Navigation pane
In an open workbook, select View > Navigation.
The Navigation pane will open on the right side of the window.
The Navigation pane can also be opened from the status bar at the bottom of the screen.Right-click on the status bar and select Sheet Number. This will add a sheet count in the status bar.
Selectthe sheet count in the status bar and select the sheet you want to see. Focus will shift to that sheet and the Navigation pane will open.
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 inits own section.Select a sectionto expand and displayits contents.
Each section will showany 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.
Make changes
Some elements can be modified directly from the Navigation Pane.Right-click on the element name to open a menu of options. Which options are available will depend on the element type.
Charts and images can be renamed, deleted, or hidden from the Navigation pane. PivotTables can onlybe renamed. There are noadditional options for PivotTables in the Navigation pane.
Note:There are no right-click options for tables.
Need more help?
Want more options?
Discover Community
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.