How To Create A Navigation Menu Pane In Excel - No VBA

Bring the Power of AI to Excel:

Pro-top: If you are going to hide or delete rows in the document, this could also impact the navigation menu sheet names. To avoid that, you can try using rectangular shapes with text in them, instead of writing in the actual cells. Just add shapes with the same size as the cells and with the same colour, as the navigation menu background, write the sheet names in them, and link them to the respective places in the document. To lock them in place and to avoid hiding them when filtering data, right-click on a shape, select Format Shape..., go to Size & Properties, Properties and select Don't move or size with cells. This way, the navigation menu items won't get hidden when you hide or delete rows.

Create this Navigation Menu Pane in seconds with our Add-In Pine BI:

--

Learn how to create a navigation menu pane in Microsoft Excel. Perfect for organizing your Spreadsheets and Dashboards in a modern, professional and engaging way.

➤ If you found this video useful, please Like, Share and Subscribe!

Need amazing Excel Dashboards and Charts? We've got you covered!
We can support you by updating your existing Spreadsheet visualizations or creating new, based on your data from scratch! For more information, visit our Services page:

Project Management Template, which was featured in the video:

Check out our other premium Excel Templates:

More free tutorials are available on our website:

Follow us on:

Modern & Professional. No Macros. Completely Unlocked.

[alinabankal]

This is exactly what I was looking for. Thank you so much for creating this. Your steps were so easy to follow I'm well on my way to making a menu driven dashboard! Thank YOU!!

[noblestride]

THANKS A BILLION!!! MADE MY SHEET CLUTTER FREE AND AMAZING!

[anthonibritto]

Your videos are so amazing and has inspired a lot. Please keep up the spirit.

[DarA-byfl]

Thank you for this tutorial. This is really impressive!

[alonsozuniga]

Thanks a lot mate, excellent explanation!

[Jennk-lbno]

Nice! Thanks for sharing! can't wait to try this for my next report

[rinne_moo]

A way to alter this is to create the dashboard on one tab, and then place a link in every other tab that links back to the dashboard tab. This might help some ppl with the kind of sheets/data you may have. I also would place this just above my headers and then freeze the two top rows to make it able to scroll through my data easily and filter easily with no problems whilst keeping the link back to the main dashboard handy at all times .

[shaniwafa]

Awesome 👍👍👍
Very simple Technic
Result is fantastic!!
Thanks for idea
Expecting more tricks and animation Technic in future

[diassetefle]

Thanks for this Amazing tutorial, it looks like a web page

[lynasoua]

Just because you used Game of Thrones character as team member names, you got my like!!!

[suhaimiabdazais]

Just found and subscribed .. This is what I'm looking for.. Tqvm

[mansiagarwal]

Hi, The tutorial is simple and easy to understand. I wanted to ask that how to hide the sub menus of "Data Input" from the other two menus.

[myrtle]

This is a huge help, however, is there a way to prevent the menu pane from being distorted page-to-page because of row height changes in the datasets (e.g. lots of wrapped text creating a larger row height)?

[clarissaconvertino]

Hi, thank you for the nice tip. In my case, each tab contains table, whose rows I want to filter eventually. Unfortunately the filtering function will hide certain rows, messing up the navigation pane. Any idea on how to fix this?