How to link between cells in Excel

One of the capabilities of Excel is to link cells together. When you have a long list of products with their sales and purchasers, you can connect the cells together. This will help you find information quickly. You can connect the cells of a single sheet or attach different cell of different sheets. Today we are going to explain how to link between cells in Excel.

Simple method to link

First, enter the phrase as a list option in one of the desired cells.

Select the upper cell and right-click on it. Then, select the hyperlink option.

How to link between cells in Excel

Now, you can perform various link operations in a variety of ways.

Link to a specified cell in the same file

In the pop-up window, go to Place in This Document. In the Type the Cell reference box, enter the name of the cell you want. Then, select the current sheet from the list of sheets in the box below it.

How to link between cells in Excel

How to link between cells in Excel

If you click on reference cell (A2 in upper image) you will go to the hyperlinked cell (C18).

Link to the other sheet and the specified cell in the same file

Again, in pop up window go to Place in This Document. In the Type the Cell reference box, enter the name of the cell you want. Then, enter the list of sheets in the box below it, each of the other sheets that you intend to.

How to link between cells in Excel

If you click on reference cell (A2 in upper image) you will go to the hyperlinked cell (B10) in By product Sheet.

Comment us on How to link between cells in Excel if you know other ways to link between cells.

How to link between cells in Excel
4.5 (90%) 18 votes

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

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