Lesson#144: How to find linked values in Excel from other Worksheets

Lesson#144: How to find linked values in Excel from other Worksheets

Hello friends, after a long time I am going to make a post for you. Here I am going to discuss the Find and Replace option in Excel. Suppose I have a worksheet filled with data. There may be some data that shows values of linked cells from another sheet. If you find a value that is linked to another sheet it can’t find normally. Here I will show you how to find the value.

In the above picture, you can see a value that is linked to another worksheet. Now I will press Ctrl+F to find the value in the worksheet.

As you can see, it shows an error like the picture above.

find linked values in Excel

To find the value linked from another sheet you need to click on the Options>> button on Find and Replace window.

find linked values in Excel

Then select the Values option in Look in: drop down.

find linked values in Excel

Now you find any values. It will show all values whether it is original from the present sheet or linked from any other sheet.

Click Here for more posts related to Find and Replace.

Now you can find linked values in Excel.

Subscribe to the channel Excelabcd for Excel-related videos.

See also  Lesson#50: 4 most useful way to use Find and Replace

Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.

0 Comments on “Lesson#144: How to find linked values in Excel from other Worksheets

Leave a Reply

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

*