• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course โ€“ Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member
  • Login

Excel Hyperlink Buttons

You are here: Home / Excel / Excel Hyperlink Buttons
Excel Hyperlink Buttons
November 20, 2013 by Mynda Treacy

I like to use Excel hyperlink buttons in my Excel workbooks to help with navigation.

I link them to a Shape that looks like a button to make it intuitive for the user, and also because I think it looks nicer than a text hyperlink.

If I have a lot of worksheets in the file I'll make an index in the first sheet and include a button back to the index in every other worksheet too. Just like in the example file.

Add hyperlinks to Excel Shapes

Another technique I like to use, particularly in dashboard report files where I might have multiple dashboards, is to create what appear to be tabs in the top of the report:

tabbed hyperlink buttons

The process is quick and easy:

  1. Insert a shape
  2. Insert the hyperlink

Letโ€™s take a look at the steps in a bit more detail, plus Iโ€™ll give you a tip to prevent your hyperlinks from breaking if you change the worksheet name or move the linked cell.

Watch the Video

Subscribe YouTube

Download the Workbook

Enter your email address below to download the sample workbook.

By submitting your email address you agree that we can email you our Excel newsletter.
Please enter a valid email address.

Download the Excel Workbook. Note: This is a .xlsx file please ensure your browser doesn't change the file extension on download.

Inserting Shapes

Youโ€™ll find the shapes on the Insert tab of the ribbon in the Illustrations group.

Inserting Shapes

I like to use the Rounded Rectangle for my buttons. To format them select the Shape then on the Drawing Tools: Format tab youโ€™ll find various formatting options.

Iโ€™ve chosen the Shape Style that makes it look like a button:

Formatting Shapes to look like a button

Once youโ€™ve entered the text on your button you can insert the hyperlink.

Inserting Hyperlinks

  1. Right-click on the shape and select Hyperlink. This will open the Insert Hyperlink dialog box.
  2. In the โ€˜Link toโ€™ options choose โ€˜Place in This Documentโ€™ and then on the right 'Type the cell reference' field enter the cell you want to land in, and select the worksheet from the list.Inserting hyperlink in button

Quickly Replicate

Once you set up one button you can easily replicate it by copying and pasting. Simply hold down CTRL and left click the Shape > CTRL+C to copy > CTRL+V to paste.

I particularly like to use this technique for my buttons that return to the index. Since these are the same on every sheet I just set up one and copy and paste it as many times as I need.

Tip: make sure you get your formatting just how you want and insert the hyperlink before copying and pasting!

Default Shape

If you find yourself applying the same formatting options every time you insert a Shape why not set it up as your default.

Once you've completed your formatting right click the Shape > Set as default.

Now when you insert any shape it will have that formatting applied. Too easy!

Prevent Hyperlinks from Breaking

Hyperlinks are great but if you change the worksheet name youโ€™re linking to, or insert cells above your โ€˜cell referenceโ€™ youโ€™ll find that the hyperlink either doesnโ€™t work anymore, or itโ€™s no longer going to the right location in the workbook.

To avoid these problems I like to give the cell Iโ€™m linking to a Defined Name. That way if I change anything in the workbook my name will automatically pick up the change and my hyperlink wonโ€™t break.

To define a name, simply go to the cell in the worksheet that you want your hyperlink to go to and in the name box type in the name and press ENTER:

Define a name for the cell you want to hyperlink to

Now when you insert your hyperlink you choose from the Defined Names list instead of the cell reference:

Choose your name from Defined Names

Excel Hyperlink Buttons
Mynda Treacy

Microsoft MVP logo

AUTHOR Mynda Treacy Co-Founder / Owner at My Online Training Hub

CIMA qualified Accountant with over 25 years experience in roles such as Global IT Financial Controller for investment banking firms Barclays Capital and NatWest Markets.

Mynda has been awarded Microsoft MVP status every year since 2014 for her expertise and contributions to educating people about Microsoft Excel.

Mynda teaches several courses here at MOTH including Excel Expert, Excel Dashboards, Power BI, Power Query and Power Pivot.

More Hyperlink Posts

Create Hyperlinked List of Files in Subfolders

Create Hyperlinked List of Files in Subfolders

Using a little VBA we can create a hyperlinked list of files from subfolders right in our Excel worksheet.
Create Hyperlinked List of Files in a Folder Using VBA

Create Hyperlinked List of Files in a Folder Using VBA

Using Excel VBA, we can create a hyperlinked list of files from a folder in our worksheet
Excel Factor 21 Hyperlink Triptych

Excel Factor 21 Hyperlink Triptych

Tips and tricks with hyperlinks to make them dynamically update as the selection in the sheet changes. Sample workbook available.
Save Time with Hyperlinks for Word, Excel and Outlook

Save Time with Hyperlinks for Word, Excel and Outlook

Use hyperlinks to make navigating in your documents easier. You can also link to external files on your hard drive to make them easier to find and open.

More Excel Posts

8 Excel in-built AI Tools

Built-in Excel AI Tools

Clean, analyze and visualize data with these Official Excel AI tools by Microsoft. Including formula writing, PivotTables, Charts and more.
excel date and time

Excel Date and Time

Everything you need to know about Excel date and time. Includes comprehensive workbook with every date and time function, plus PDF version.
10 mistakes to avoid when using excel formatting

10 Mistakes to Avoid With Excel Formatting

These are the Excel formatting habits that drive me crazy and what you should do instead to ensure you use formatting effectively.
linear regression

Excel Linear Regression

Excel linear regression is easy with the built-in tools. Use charts to plot linear regression or use the Data Analysis Toolpak.
speed up slow excel files

How to Improve Excel Performance

How to improve Excel performance and the various causes of slow Excel files so you can speed up Excel and avoid problems in future.
Securely Share Excel Files

Securely Share Excel Files

Securely share Excel files stored locally, on OneDrive or SharePoint. Prevent editing or downloading, specify who can open and edit the file.
excel check boxes

Interactive Excel Check Boxes

Excel check boxes are interactive elements you can link to formulas, charts, conditional formatting and more.
tips for working in multiple excel files

Hacks for Working in Multiple Excel Files

Awesome tips for navigating, arranging and working in multiple Excel files. Guaranteed to streamline your workflow and increase productivity.
chatgpt for excel

ChatGPT for Excel

Using ChatGPT for Excel can be hit and miss. Learn the best uses for ChatGPT to make your Excel life easier and what to avoid using it for.
excel templates

Where to Find Free Excel Templates

Where to find free Excel templates and how to create your own Excel templates. Using templates saves time and effort.


Category: ExcelTag: Hyperlink
Previous Post:No, youโ€™re not going mad, itโ€™s just Excelโ€™s Implicit IntersectionNo, youโ€™re not going mad, itโ€™s just Excelโ€™s Implicit Intersection
Next Post:How To Enable the Developer Tab in ExcelHow To Enable the Developer Tab in Excel

Reader Interactions

Comments

  1. Taylor

    April 13, 2022 at 7:38 pm

    Hi,
    Is there anyway I can get the hyperlink link shape/button to be based on the hyperlink in another cell?
    I have a HR dashboard that pulls up relevant employee info based on the name searched for or selected from the search bar/dropdown list at the top.
    Currently data is populated from a table on another sheet by having shapes/textboxes on the dashboard = hidden cells running an iferror formula based on the employee selected. Ideally I would also like to have hyperlinks (same as above i.e. in shapes to look like buttons) on the dashboard linking to HR folder, pdf of contract and pdf or jpeg of passport on file. However I can’t figure out a way to insert hyperlinks based on a hyperlink in another cell.
    It would obviously have to change based on which employee is selected. If joe blogs is selected the hyperlinks would go to his HR folder, contract or passports, if jane doe is selected it would go to hers.
    Thanks,

    Reply
    • Mynda Treacy

      April 13, 2022 at 8:57 pm

      Hi Taylor,

      You’d have to write some VBA code to dynamically update the hyperlinks for each button as there’s no formulaic way to link shapes to hyperlinks in cells.

      Mynda

      Reply
  2. Margut

    February 27, 2021 at 10:48 pm

    Hi there, I hope you can help me, is it even possible to link a shape from main tab to other tabs on the same sheet however is hidden?

    Reply
    • Mynda Treacy

      February 28, 2021 at 2:11 pm

      Not is a sheet is hidden.

      Reply
  3. Letsatsi

    September 5, 2020 at 3:06 pm

    I have a shop page and i inserted ‘Contact us’ navigation page at the bottom with the customer name and email and a send hyperlink button. The problem is that i copied all these from someone and pasted, now when i click the send button, it takes me to that person’s site that I copied from. I tried to edit the link but it does the same..

    Reply
    • Mynda Treacy

      September 5, 2020 at 3:14 pm

      If editing the link doesn’t fix it then you’ll have to enter them again. Not sure why editing it wouldn’t work though. I’m assuming right-clicked to edit the hyperlink, not just typed something new in the cell.

      Reply
  4. Amer

    June 27, 2018 at 8:43 pm

    Hello
    Any user can move the hyperlink button .haw can I protect
    Thank you

    Reply
    • Catalin Bombea

      June 27, 2018 at 11:45 pm

      You have to protect the worksheet, they will not be able to move the button.
      Catalin

      Reply
      • Amer

        June 30, 2018 at 2:07 am

        Thank you
        The cells was protect but the hyberlink button no
        (You can’t edit but you can move or deleted )
        Can you please help me

        Reply
        • Catalin Bombea

          June 30, 2018 at 2:20 pm

          Hi Amer,
          Right click the shape, Size and Properties, look into Properties section, the shape should have the Locked property checked by default.
          Again, the worksheet must be protected to lock the shape, not the cells. When protecting he worksheet, there are other things you can use from protect sheet dialog options, Edit Objects is usually unchecked by default, make sure it’s unchecked.
          Catalin

          Reply
          • Amer

            July 1, 2018 at 2:13 am

            Hi catalin
            Thankyou very much. It’s working
            I’m so happy thank you again

          • Catalin Bombea

            July 1, 2018 at 6:14 pm

            Hi Amer,
            great, glad to hear you managed to make it work.
            Cheers,
            Catalin

  5. Muhammad Sufyan

    April 18, 2018 at 8:32 pm

    I have many shapes like Districts of Province, so I try to clink anyone to show result value in one excel cell.
    Anyone Help me.

    Reply
    • Mynda Treacy

      April 18, 2018 at 9:32 pm

      Hi Muhammad,

      Thanks for your question, however I’m having trouble picturing what you’re trying to do. Please post your question on our Excel forum where you can also upload a sample Excel file so we can see your question in context.

      Mynda

      Reply
  6. Slobodan Horvatic

    July 9, 2014 at 6:43 pm

    Hello everybody,

    great techinuque indeed, looks really nice and adds value to the report!
    There is one thing I just recently discovered though. There is a way to get rid of nasty (default) screen tip message when you hoover over the hyperlink. So, if you go to EditHyperlink, on the top right corner you can find “Screen tip” button. Just type more user friendly name and that is it :))

    Reply
    • Mynda Treacy

      July 9, 2014 at 7:18 pm

      Great tip, thanks Slobodan ๐Ÿ™‚

      Reply
  7. duncan

    January 21, 2014 at 9:24 am

    Very good tutorial.

    A few years ago I prepared a series of self directed learning spreadsheets for accountibg students. I wanted to hyperlink from my menu to the relevant sheet/exercise. Excel 2000 or thereabouts, I think … couldn’t be done!

    Things can only get better!

    Duncan

    Reply
    • Mynda Treacy

      January 21, 2014 at 2:17 pm

      Onwards and upwards ๐Ÿ™‚

      Reply
  8. nitin

    December 4, 2013 at 5:20 pm

    Is there a way by which we can insert formula which relate to data in other text boxes ?
    Meaning: I have a sub index of my application which has hyper links to various sheets in the work book. against each sub-index item, I also have a sub total of the relative sheet so I have a summary of all the sheets in the sub index.

    I would like to use your hyper-link shapes for the hyperlionks but would like to complement each shape with a counter shape with the sub total of that work sheet…..

    Reply
    • Catalin Bombea

      December 6, 2013 at 1:32 pm

      Hi,
      Please upload a sample of your workbook, it will be a lot easier for me to understand the situation! Every details you can give is important, so be generous with details ๐Ÿ™‚ ,i will gladly help you. You can use the Help Desk to upload an example file: https://www.myonlinetraininghub.com/helpdesk/
      Cheers,
      Catalin

      Reply
  9. Philip Treacy

    November 22, 2013 at 11:39 am

    Doug Drury emailed me asking how to open an Excel template using this hyperlink method.

    Using a hyperlink to do this causes the template to be opened for editing. Whereas double clicking the template file opens a new workbook using that template.

    To use a shape within a workbook to open a new workbook based on an existing template, you need to use a macro and assign the macro to the shape. Fortunately it’s a very simple macro :

    Sub OpenTemplate()
    
    Workbooks.Add Template:="C:\Users\PGT\AppData\Roaming\Microsoft\Templates\test.xltx"
    
    End Sub
    

    Just add that into a module in your workbook, change the path to point to your template, assign it to your shape and when you click the shape, a new workbook will be created based on your template.

    Phil

    Reply
  10. Rachael Hanna

    November 21, 2013 at 6:32 am

    An(other) excellent tutorial – I will be sharing this one with a few friends. I often wondered if something like this were possible, because it would save a lot of time. Now I know that it is.
    Regards

    Reply
    • Mynda Treacy

      November 21, 2013 at 9:40 am

      Thanks, Rachael ๐Ÿ™‚

      As another member pointed out, you can also insert hyperlinks to take you to locations outside of your workbook. A bit like icons on your desktop, you can have an Excel workbook with hyperlinks to your most common web pages, or programs/files etc.

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Current ye@r *

Leave this field empty

Sidebar

More results...

Popular Content

  • 10 Common Excel Mistakes to Avoid
  • Top Excel Functions for Data Analysts
  • Secrets to Building Excel Dashboards in Less Than 15 Minutes
  • Pro Excel Formula Writing Tips
  • Hidden Excel Double-Click Shortcuts
  • Top 10 Intermediate Excel Functions
  • 5 Pro Excel Dashboard Design Tips
  • 5 Excel SUM Function Tricks
  • 239 Excel Keyboard Shortcuts

100 Excel Tips and Tricks eBook

Download Free Tips & Tricks

239 Excel Keyboard Shortcuts

Download Free PDF

mynda treacy microsoft mvpHi, I'm Mynda Treacy and I run MOTH with my husband, Phil. Through our blog, webinars, YouTube channel and courses we hope we can help you learn Excel, Power Pivot and DAX, Power Query, Power BI, and Excel Dashboards.

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel Office Scripts
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook

Sign up to our newsletter and join over 400,000
others who learn Excel and Power BI with us.

 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate
  • Sponsor Our Newsletter

Support

  • Contact
  • Forum
  • Helpdesk – For Technical Issues

Copyright © 2023 ยท My Online Training Hub ยท All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.