Excel - How to use the Navigation pane for charts, tables, PivotTables, pictures, and worksheets
2.2 هزار بار بازدید -
3 سال پیش
-
The Navigation pane in Excel
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
support.microsoft.com/en-us/office/use-the-navigat…
#excel #exceltips #microsoftexcel #chrismenard #chrismenardtraining
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera – amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod – amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera – amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – chrismenardtraining.com/camtasia
○ Screenshots – Snagit – chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – www.tubebuddy.com/chrismenard
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!
3 سال پیش
در تاریخ 1400/07/28 منتشر شده
است.
2,207
بـار بازدید شده