The Navigation pane in Excel is 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 pane can help.
Find and access elements such as tables, charts, PivotTables, and images within 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 interpret your workbook.
- 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.
- Select the 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.