QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Mobile
  • Email
    • Gmail
  • Wiki

How to create Links in MS Excel 2016?

By Neha T Leave a Comment

MS Excel allows you to create a link between two worksheets of the same workbook, or between two different workbooks. The beauty behind this linking is that if you modify the original data, you will also experience modification in your linked data as well. In this article, I have explained the steps to create links in MS Excel 2016.

Steps to create Links in MS Excel 2016:

Step 1: Select the range of the cells of which you want to create a link. and copy the selected range of cells.

Here, for demonstration, I copied the data that you can see highlighted by the red box in the picture below, from Workbook “Book1“.

how-to-create-links-in-ms-excel-2016-step-1Step 2: Now it is up to you where you want to paste this data to create a  link. You have a choice to paste this data:
To same sheet of the workbook, from where you copied it.
To a different sheet of the same workbook.
To a different workbook.

For demonstration, I opt for a different workbook “Links Test“. Now you must know how to paste the data to create a link.

how-to-create-links-in-ms-excel-2016-step-2For that, select a cell on the sheet where you want to paste your data and click on the down arrow of Paste button present under Clipboard group of Home tab. Among the offered options click on Paste Special...

Step 3: A Paste Special dialog box will pop up. Click on the Paste Link button, present at the bottom of the dialog box. This will paste your copied data to your selected location.

how-to-create-links-in-ms-excel-2016-step-3So the data I copied from Book1 workbook is now pasted to Links Test workbook.

Step 4: Time to check whether we succeeded in establishing a link between the two data; the original data that you copied and the data that you pasted.

For demonstration, I select a cell (Meridian) from Links Test workbook, where I pasted my data. Observe its Formula bar; you can view the link, which expresses the source of the selected cell’s data.

Like it expresses that the selected cell data is linked to cell D4, in Sheet1 of Book1 workbook.

how-to-create-links-in-ms-excel-2016-step-4

Step 5: To experience the working of links, let us modify a cell in a referenced data i.e. your original data. Like I modified the city of Jim Taw from Columbus to Paris in Book1 workbook.

how-to-create-links-in-ms-excel-2016-step-5Step 6: Now check referencing data, you will find it to be modified. Look at the picture below you will find the city of Jim Taw is also modified to Paris in Workbook “Links Test“.

how-to-create-links-in-ms-excel-2016-step-6Thank you. Keep reading.

You Might Also Like:

Create a named range in Excel feature imageHow to Create Named Range in Excel? how-to-split-text-of-cells-in-ms-excel-2016-featured-imageHow to Split Text in a Cell in MS Excel 2016? how-to-freeze-row-and-column-in-ms-excel-in-2016-featured-imageHow to Freeze Rows and Columns in MS Excel 2016? how-to-sort-data-in-ms-excel-2016-featured-imageHow to Sort Data in Ms Excel 2016? how-to-break-links-in-ms-excel-2016-featured-imageHow to break Links in MS Excel 2016? how-to-create-macro-in-ms-excel-2016-featured-imageHow to Create Macros in MS Excel 2016? how-to-create-a-drop-down-list-in-ms-excel-2016-featured-imageHow to Create a Drop-Down List in MS Excel 2016? How to add in Excel-featured imageHow to Add or Sum in MS Excel 2016?

Leave a Reply Cancel reply

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

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Add Hyperlink to Another Sheet in Excel?
  • How to Add and Remove Watermark in Excel
  • How to use Relative and Absolute Cell Reference in Excel?
  • How to Enable and Disable Scroll Lock in Excel?
  • How to Use INDEX and MATCH Functions in Excel?
  • How to Make Bar Graph in Excel?
  • How to Count Duplicate Values in Excel?
  • How to Wrap Text in Excel?
  • How to Round off Numbers in Excel?
  • How to Create a Bell Curve in Excel?

Related Searches

  • How to Crop and Zoom Video in Power Director?
  • How to create a shopclues account
  • How to delete Bookmarks in Google Chrome?
  • How to change Microsoft Word theme
  • How to Password protect your MS PowerPoint file?

Copyright © 2023 · QueHow · Contact Us