If you have the subscription version of Excel then you have access to the Navigation Pane. This allows you to navigate between sheets and see the structure of the sheets in your file.
Tag Archives: navigation
Navigation Columns in Excel
Great for long reports
When working in long spreadsheets it can be a good idea to use a navigation column to make it easier to move between the different sections.
Activating a sheet in VBA
Here’s the problem. You have a number of sheets that are named after Department codes. Those sheets contain the details for each department. You have reports throughout the model that refer to these department codes. You want to be able to select a cell that contains a department code and click a button that will take you to that department’s sheet.