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.

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.

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.

Other Excel articles

Excel 3D Reference - easily reference data on another worksheet

A 3D reference in Excel is a simple method to pull data from another cell, another worksheet, or a range of worksheets. Changes in the source will reflect in the destination.

What is the Middle Class and Are You in the Middle Class?

What is the middle class and are you in the middle class? To figure out if you are in the middle class, we need to know the median household income, how many people are in your household, and where you live.

Excel - 3 Cool methods to extract text from the beginning of a text string

We frequently need to extract part of a text string in Microsoft Excel. We are going to extract the first part of a text string. Examples of text string parts you would extract include product numbers, employee IDs, and accounting numbers.

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.

Analyze Data Command in Excel - Ask questions about your data using AI

Need to quickly understand your data in Excel and ask questions about your data? Easy to do using Excel's Analyze Data command located on the Home tab in Excel. Analyze Data using Artificial Intelligence (AI).

Excel - Easily Break Up Data using Subtotals and Conditional Formatting

After sorting in Excel, we will look at two great methods for separating blocks of data or showing a clean separator between our groups.

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

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

YouTube video

Other Excel articles

Open the Navigation Pane

Explore the elements

Other Excel articles

Excel 3D Reference - easily reference data on another worksheet

What is the Middle Class and Are You in the Middle Class?

Excel - 3 Cool methods to extract text from the beginning of a text string

Artificial Intelligence (AI) in Microsoft 365

Analyze Data Command in Excel - Ask questions about your data using AI

Excel - Easily Break Up Data using Subtotals and Conditional Formatting

Chris Menard

Categories