Query on links in Excel

I have one work sheet whith one list. Let us call it list A. I have some workings in another sheet. (Say B) I have linked(Given reference) of A to B. Now I would like to ensure that every thing in A is mapped/ linked to B. How to do this without checking each link which takes lot of time? Are there any shortcuts for checking this? Thanks

Replies (7)
Originally posted by :Anil
"

I have one work sheet whith one list. Let us call it list A. I have some workings in another sheet. (Say B) I have linked(Given reference) of A to B. Now I would like to ensure that every thing in A is mapped/ linked to B. How to do this without checking each link which takes lot of time? Are there any shortcuts for checking this? Thanks

u can use function of vlookup

"


 

Thanks.
 

Thanks on letting me know about linking using vlookup.

 

In the sheets I have mentioned linking is already done. It is done without using vlookup.

 

I would like to know how I can check whether everything in list A is linked to sheet B

 

Thanks.

 

 

 

U can use goal seek or auditing toolbar for tht

How?

Follow this u will come to know about all the formulas...

Press Ctrl+` (the button above your tab key) and the worksheet shows you all the formulas you have used in that worksheet.

Your screen looks ittle weird, but will show you all the formulas in that worksheet.

TO return to nomal mode again press the same key.

 

 

 

Originally posted by :Anil
" I have one work sheet whith one list. Let us call it list A. I have some workings in another sheet. (Say B) I have linked(Given reference) of A to B. Now I would like to ensure that every thing in A is mapped/ linked to B. How to do this without checking each link which takes lot of time? Are there any shortcuts for checking this? Thanks "

I agree with Ashish

Follow this u will come to know about all the formulas...

Press Ctrl+` (the button above your tab key) and the worksheet shows you all the formulas you have used in that worksheet.

Your screen looks ittle weird, but will show you all the formulas in that worksheet.

TO return to nomal mode again press the same key.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
10 November 2026
FP&A Executive

Gujarat Guardian

Ankleshwar

CA Final

View Details
Company
ARTICLESHIP 16 November 2026
Audit Executives

Loonker Godawat And Company

Bengaluru

B.Com

View Details
Company
20 November 2026
Charted Accountant

Cothas Coffee Co.

Bengaluru

CA

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
31 October 2026
Accountants

sankaran and krishnan

New Delhi

B.Com

View Details
Company
ARTICLESHIP 14 November 2026
Article Assistant

Jitendra Agarwal & Associates

Bengaluru

CA Inter

View Details
Company
16 November 2026
Indirect Tax Associate

Sekhri Kanodia & Associates

Mumbai

B.Com

View Details
Company
ARTICLESHIP 25 October 2026
Article Intern (CA Articleship)

Arpan Bohra & Co

Hyderabad

CA Inter

View Details