Add Navigation Menus to Your Excel Workbooks

[@zachrickard4241]

This is just about one of the coolest things I've ever seen on Excel. I've used the annual plan videos for a project, but this might end up being the 'wow factor' I need (as in 'wow factor' is a part of our grade). Thank you so much!

[@DSMStrength]

Hey Zach, thanks so much for checking out the video... I have my students include a wow factor as well! would love to see what you come up with.

[@Pitman335]

Awesome!! That is very informative, Thanks a million!

[@Me_ThatsWho]

Great video- subb'd ! I was playing around with Excel last week & I figured out how to do this. Seemed like a neat trick (or perhaps more like a hack). I'd just add this: at a certain point, users need to hop over to using a database if that's what really fits. It offers this kind of functionality without the need for a hack. The fun zone for me is to explore how I can integrate Excel with a database- the best of both worlds. Would welcome your ideas. Thanks.

[@DSMStrength]

thanks for taking the time to check out the video! Typically I am dealing with strength and conditioning coaches and fitness professionals so a data base is likely not as important because the amount of data will not be as high as a lot of other professions.. but I agree that sould be a consideration at some point and with something like power query in excel you can integrate pretty well!

[@alaaeddine6340]

thank you so much that was amazing

[@PamWright-kn6de]

This was definitely very useful. My follow up question is now that i have my navigation menu created in each worksheet I am ready to populate my worksheets that have different formulas and links etc in them. I'm not sure how to ask this but i essentially want to 'disconnect' the navigation pane from the rest of the worksheet so that changes i make in the body of the worksheet don't change the format/appearance of the navigation menu. Can I/How can I do this? Thanks

[@mittenwald3679]

you could use ONLY the icons part , or insert Text Boxes , and then right click -> properties -> dont move and size with cells

[@arqamqazi9239]

Amazing n informative

[@DSMStrength]

thank you for watching!

[@barcelonefrance8661]

Hi! is it possible to lock the menu? The goal being that if we scroll, the menu remains visible

[@DSMStrength]

you can lock the rows or columns but it will also lock all of the content on the sheet if you scroll down .. what I would recommend is to put your menu along the top of your sheet and lock the first couple rows. Hope that helps.

[@adamsykes5755]

hello could i get a download link for this please?

[@nikkrn4926]

nice!

[@DSMStrength]

thank you

[@axldrum4534]

XD

[@DSMStrength]

thank you i think