Open the navigation pane

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. 

• To open, go to the View tab and select Navigation. The Navigation pane opens on the right.

• To close the Navigation pane, select the X in the upper right corner of the pane.

For more info, see Use the Navigation pane in Excel.

The Navigation pane isn't available in Excel for the web. You can, however, use the Navigation pane in the Excel desktop app.

• To open the desktop app, at the top of the ribbon, select Editing > Open in Desktop App.

  

Don't have the Excel desktop app? Try or buy Microsoft 365.

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. 

1. On the View tab, select Show.

2. In the Show pop-up, select Navigation.

To close the Navigation pane, select X in the upper corner.