Cool Tricks with Excel Hyperlink Buttons

Great - your Defined Name has solved a problem I have been struggling with

Wonderful video! Explained all uses very well! Thank you!! This is a lifesaver!

Thanks Mynda, this is great!

To create the index button for all tabs, couldn't you select all the tabs you want to create the button for and do it only once?

Hyperlinks don't seem to work on excel for ios :( Would be so nice to be able to have functioning buttons in excel for ios. Any ideas?

Help. How to creat a button to work on an iPad. I can do one on my laptop no problem

I Have so many videos to see, you are an amazing teacher!

Great video as always :)

I have added a hyperlink on a sheet to another TAB in my workbook but I cannot used the = to link cells using the hyperlink. I must manually click the tab. Is there a way to do this?

This is brilliant

When I am sharing my sheet on a shared drive in office using hyperlink function (not onedrive or 365), my colleague is unable to open the links to view the files. Any help??

Liked the video 👏🏻 i have a question Can i add pictures as button instead

Thank you for sharing your videos..

Many Thanks. Do you have a spreadsheet that includes the data for your charts. Thanks again

Thanks for great Vid. One question. How do i add links like this on my ipad. I cannot seem to work it like you suggest

Very useful. Thanks sharing this with us.

Loved this. It made a report I designed look much more professional. Thank you!

Thanks for a great video. I need some help regarding the navigation bar. I have bigger sheets with large data so when I scroll down or right my navigation pane also moves and disappears (even freezing panes do not work here), I want my navigation pane to stay on screen always so that I could navigate the other sheets through this pane. (I don't want to use VBA plz). Thanks and regards.

Lady, That was fantastic!!!

thank you great video

Very useful

i have been trying to do something similar, but its really difficuly to keep it updated as the excel grows. Hopefully Microsoft implements the Navigation Menu that is in word, which is currently on insider
beta channel

This channel provides the absolute best and most comprehensive excel training on the internet. Absolutely brilliant training. And I cannot believe that it's free.

Thanks for all the tutorials and examples.

Love the tutorial ❤️ can you have another video concerning icons as hyperlink buttons for dashboard? Thank you!

Brilliant, Mynda.
"Rinse and Repeat" 😊❤

You are always Amazing!!!

Can you make a video on how to use excel for inventory management for a small business.

You are just extra ordinary, fantastic, mind blowing madam.

Very educative !!. Thank you Mynda

Very good video Mynda. I’ve been using the hyperlinks for years but never knew about being able to assign them to buttons. Tabs approach’s very clever.

Greetings. Is there any way to prevent broken links if a list with links is sorted? Thanks.

Wow

Thank you. Haven't seen that for awhile. Awesome refresher for me.

Mynda,
How can we refer to any table by using hyperlinks?

Simply Great !!!!!🙏

Hi Mynda. Some great tricks and techniques here! Thanks for sharing :)) Thumbs up!!

Amazing !! thank you

How I love watching your video tutorials with different interesting solutions! Thank you for your hard work! I am Russian-speaking and you are somewhat similar to Nikolai Pavlov from Russia.

Nice Job )

Looks great, but... wouldn't be easier just to click on the sheet page...

Good teacher 👍 student from India 🇮🇳 love you 🙏

Great tutorial. Love your work! I have a question. I share workbooks in the cloud with only read permission for users. Does this work with only read permission or how do you make it work?

Thank you for the information Mynda. All is perfect, as always!!

Can u help with lazy loading web page , as it returns only 20 elements

Very cool idea Mynda! Thanks for sharing! 😊👍

Great video! Perfect timing to see this as I am searching for the exact tutorial! Subscribed! Keep it up!

Nice video thank you for your hard work 👍

Thanks Mynda, very elegant solution