Learn how to create a Navigation Menu Pane in Excel
In this video, we'll be creating a navigation menu in Excel, which is perfect for organizing your Spreadsheets and Dashboards in a modern, professional and engaging way.
This method is easy to create and results in a fantastic way to navigate around a complicated Excel file.
No Macros/VBA or Add-Ins are going to be needed, just Microsoft Excel.
One thing to note here - when using a vertical navigation menu, you'll be hiding parts of it when filtering data. If you plan on using a lot of filters in your file, one thing you might do is make the navigation pane horizontal rather than vertical. Just create it in the first 4 rows, instead of columns of each sheet. The functionality will be the same, it will still look amazing and you'll be able to filter data without hiding elements of the menu itself!
If you found this video useful, make sure to like it, share it and subscribe to our YouTube Channel! There, you'll find more free video tutorials.
Also, make sure to check out our Excel add-in Pine BI, which allows users to create advanced charts in seconds and help create dynamic Dashboards.
You can also review our Premium Templates, which are already set up and ready to use - all you need to do is just add your data!
Check out our Premium Templates