Learn Excel Now

Conquer the Fear of Excel

  • Home
  • Training
    • Excel
    • MS Office
    • Outlook
    • PowerPoint
    • Word
    • OneDrive
    • Google
  • All-Access
  • eLearning
    • Excel Foundations
    • Micro Courses
      • Simply Excel
  • Resources
  • Login

Hyperlinking In Excel: To the Web or to Another Worksheet

May 18, 2016 by Tyrone Pernsley

You might already know how to hyperlink a cell to external sources, namely to the web. In case you don’t, here is a quick tutorial on that:

  • Copy the URL of the website you want to hyperlink to
  • Click on the cell you want to hyperlink from
  • Right click and open the option that says “Hyperlink”
  • By default, Excel sets the dialogue box for hyperlinking to external web content
  • Paste the URL of the site you’re hyperlinking to (you can also type it if you have that kind of time)
  • Then click Okay and you are cell is hyperlinked!

Hyperlinking in Excel Gif 1

But did you also know you can hyperlink to other sources – such as within the worksheet itself?

This is convenient for large workbooks where data on one worksheet references data on another worksheet. One of my favorite things to do with large workbooks is to create a Table of Contents that identifies what each worksheet contains. Then, using the hyperlink option, anyone using the workbook can click right to each worksheet.

To do this:

  • First select a cell in one sheet that you want to create a hyperlink to another sheet
  • Right click the cell and click the hyperlink button
  • From the menu that appears, click the Place in This Document button in the Link to box
  • Select the sheet that you want to hyperlink to and enter the text you want to display in the Text to display box (or keep the text the same if you want)
  • If you want to hyperlink to a specific cell in another sheet, specify the cell in the Type the cell reference box.
  • Click OK and you will see that when you click on the data it will bring you to your desired worksheet!

Hyperlinking in Excel Gif 2

We hope you found today’s quick and easy Excel lesson beneficial. Don’t forget to follow ups on Social Media and subscribe to the blog to get convenient, quick tips like this, and other great Excel training tips so that you can take the fear out of Excel.

Like Learn Excel Now? Sign up for the newsletter!

-Kevin, Learn Excel Now

All Access Subscription
Our 1-year all-access subscription provides step-by-step guidance for mastering Microsoft Office applications, with workshops, exercises and quick reference eGuides. It's perfect for anyone that needs to brush up on certain skills or even folks who need to learn the programs - from a beginner’s level.
Excel Foundations
Take the fear out of Excel with this 20 module self-paced training course. You will cover the most essential topics to develop a solid foundation of Excel or a lifetime of mastery.

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

  • Home
  • Training
  • All-Access
  • Excel Foundations
  • Resources

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-484-259-7664 or 1-800-964-6033
660 American Ave
Suite 203
King of Prussia, PA 19406

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2023 ­Learn Excel Now

Terms of Service

Privacy Policy

Copyright © 2023 · News Pro Theme on Genesis Framework · WordPress · Log in

WELCOME BACK!

Enter your username and password below to log in

Forget Your Username or Password?

Reset Password

Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

Log In