Meet Excel’s shiny new Navigation Pane 🤩. This pane is like a Table of Contents on steroids, and makes it easier than even to locate and manage the elements in your workbook. Check out the above gif for an example: we’ve got a workbook with several tabs that all have their own table, chart, pivot table, and image elements to them. Instead of scrolling through all of these tabs to find something we’re looking for, we can use the Navigation Pane!
To open the Navigation Pane, go to the “View” tab on the ribbon and select “Navigation.” Now we can easily view all of the worksheets and their elements simultaneously, and we can jump to any of these elements by selecting them in the navigation pane! If we wanted to go even faster, we could enter a search term in the search bar - we could enter “sparklines,” for example, to instantly open the sparklines tab!
Get ready to save a ton of time! This is way more efficient than scrolling through tabs!
