Excel - How to use the Navigation pane for charts, tables, PivotTables, pictures, and worksheets

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. 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.

Chapters:
0:00 Intro
0:24 Navigation Pane
1:25 Search Navigation Pane
1:38 Elements in Navigation Pane
3:04 Turn on Sheet Number

Add Sheet Number to the Status Bar
Right-click on the status bar and select Sheet Number. This will add a sheet count in the status bar.

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.

The Navigation Pane works in Excel for Microsoft 365.

Microsoft Support page for the Navigation Pane

#excel #exceltips #microsoftexcel #chrismenard #chrismenardtraining

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[markwood]

Hi Chris. I think there is way of making the pane on the right float in 365. Any chance you can do a one minute special on how to do this please?

[userme]

Hi thanks for the video. I have 365 and when I went to View Tab, I could not see the Navigation Pane! How can I get that icon? Thank you.

[vanillavey]

i cant delete anything :( right clicking doesnt d anythng