How to Create Links Between Ranges in Microsoft Excel 2010

To quickly create links between ranges, we need to use the Paste Special option in Microsoft Excel 2010.

Paste Special: You can use the Paste Special option to paste specific cell content or attributes such as formula, formatting, comments, etc.  Paste link is a part of Paste Special.

Let’s take an example to understand how we can quickly create links between ranges.

We have data pertaining to quantity sold in Excel. We need to create a link to the range C2:C9 in the range E2:E9.

img1

To quickly create the links between ranges, follow the below given steps:-

  • Select the range C2:C9.
  • Copy the range by pressing the key Ctrl+C on your keyboard.
  • Select the cell E2.
  • Right click with the mouse.
  • From the short cut menu, click on Paste Special.

img2

  • The Paste Special dialog box will appear.

img3

  • In the left bottom corner, Click on the button named “Paste Link”.
  • Click on ok.
  • The link will get created.

img4

img5

Note: When you make any changes to the data, the link will be changed too.  See the above screenshot.

 

Similarly, we can create links between two worksheets in excel.

This is how we can quickly create the links between ranges in Microsoft Excel.

Leave a Reply

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

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube