Excel doubt
This query is : Resolved
06 February 2011
Hello Experts,
I have a small doubt in excel.
Lets suppose there are 3 sheets in workbook.
AA1 in sheet 2 = A1 in sheet 1. Now A1 is linked to AA1.
If I want to know if A1 is linked to any other cells in workbook is there any shortcut to check?
Please reply.
Sumitha
I have a small doubt in excel.
Lets suppose there are 3 sheets in workbook.
AA1 in sheet 2 = A1 in sheet 1. Now A1 is linked to AA1.
If I want to know if A1 is linked to any other cells in workbook is there any shortcut to check?
Please reply.
Sumitha
06 February 2011
Short Cut to Check :
I haven't found such shortcut, but if you
change the values of A1 as some thing like
ppppp you can see manually the linked cells
in respective sheet.
After finding it out, you may repale the values of the cell A1, with original value by pressing ^Z.
If you receive any short cut , please inform.
I haven't found such shortcut, but if you
change the values of A1 as some thing like
ppppp you can see manually the linked cells
in respective sheet.
After finding it out, you may repale the values of the cell A1, with original value by pressing ^Z.
If you receive any short cut , please inform.
Message likes :
1 times
06 February 2011
Sir,My doubt is for example in financials we link items in balance sheet, p&L and schedules to TB.
If i go to TB directly can i know where each item is linked rather than going to Balance sheet, P&L and schedules to see the link.
Waiting for your reply.
Sumitha
If i go to TB directly can i know where each item is linked rather than going to Balance sheet, P&L and schedules to see the link.
Waiting for your reply.
Sumitha
06 February 2011
Sir,My doubt is for example in financials we link items in balance sheet, p&L and schedules to TB.
If i go to TB directly can i know where each item is linked rather than going to Balance sheet, P&L and schedules to see the link.
Waiting for your reply.
Sumitha
If i go to TB directly can i know where each item is linked rather than going to Balance sheet, P&L and schedules to see the link.
Waiting for your reply.
Sumitha
06 February 2011
I am not certain but you may get certain useful information in Excel Tools menu.
You will find Formula Auditing command.
You try them. I think you may get the solution.
You will find Formula Auditing command.
You try them. I think you may get the solution.
Message likes :
1 times
06 February 2011
Hey Sumitha,
I guess u wanna trace dependent, Try this CTRL + ]
Let me knw if u hav ny other issue.
Regards
Juzer
I guess u wanna trace dependent, Try this CTRL + ]
Let me knw if u hav ny other issue.
Regards
Juzer
06 February 2011
Hello Juzer,
Thanks for your note.
No Actually it does not work.
Example: Cell A1 in sheet 1= Rs.1000
Cell A1 in sheet 2= Cell A1 of sheet 1.
Now if you go to cell A1 in sheet 1 and press Ctrl ] it will not work i.e it will not show you that it is linked to cell A1 of sheet 2.
Please reply.
Regards,
Sumitha
Thanks for your note.
No Actually it does not work.
Example: Cell A1 in sheet 1= Rs.1000
Cell A1 in sheet 2= Cell A1 of sheet 1.
Now if you go to cell A1 in sheet 1 and press Ctrl ] it will not work i.e it will not show you that it is linked to cell A1 of sheet 2.
Please reply.
Regards,
Sumitha
07 February 2011
Hey Sumitha
Gt u, press f5, you will get dependent's
list, select the reference from the list.
I hope it will work for you.
Regards
Juzer
Gt u, press f5, you will get dependent's
list, select the reference from the list.
I hope it will work for you.
Regards
Juzer
Message likes :
1 times
07 February 2011
I tried it and it does not work .
Please suggest what to do?
Thanks and regards,
Sumitha.
Please suggest what to do?
Thanks and regards,
Sumitha.
08 February 2011
Click on Cell A1 in Sheet 1
Press "Ctrl ["
U vl automatically be in Cell A1 in Sheet2
It vl certainly help u
revert if need more on it.....
Press "Ctrl ["
U vl automatically be in Cell A1 in Sheet2
It vl certainly help u
revert if need more on it.....
08 February 2011
Dear Navin,
It will not work. Ctrl [ will work only on A1 sheet 2 but not sheet 1.
It will not work. Ctrl [ will work only on A1 sheet 2 but not sheet 1.
08 February 2011
Then....
try 'Trace Dependents' on A1 Sheet1
An Arrow will appear
Now double click on the starting point of Arrow
Go To box will open
There u can see which cells in which sheets are linked to the selected cell
try 'Trace Dependents' on A1 Sheet1
An Arrow will appear
Now double click on the starting point of Arrow
Go To box will open
There u can see which cells in which sheets are linked to the selected cell
08 February 2011
Hi Naveen,
I tried doing that it will not work.
I am using excel 2007 and tried F5 and then dependents. But no arrow would appear.
What shall I do?
Please reply.
Sumitha
I tried doing that it will not work.
I am using excel 2007 and tried F5 and then dependents. But no arrow would appear.
What shall I do?
Please reply.
Sumitha
09 February 2011
Dear,
I, myself, am using Windows 2007.
U should rather ensure that u have original Windows 2007 installed.
Otherwise, u should take technical assisstance from some computer expert.
Thanx...
Appreciate...
Keep on posting...
I, myself, am using Windows 2007.
U should rather ensure that u have original Windows 2007 installed.
Otherwise, u should take technical assisstance from some computer expert.
Thanx...
Appreciate...
Keep on posting...
10 February 2011
Hi Navin,
I am using original windows 2007.
I dont understand how it does not work on my system,
Are there any options to be ticked in excel options?
Regards,
Sumitha
I am using original windows 2007.
I dont understand how it does not work on my system,
Are there any options to be ticked in excel options?
Regards,
Sumitha
11 February 2011
I suggest u to perform the following
steps once again carefully:
1. Go to Cell A1 in Sheet1
2. Click 'Trace Dependents'
3. An Arrow will appear
4. Double Click on the starting point of Arrow
5. 'Go To Box' will open
6. Select the path in 'Go To Box'
7. Click 'Open'
8. U will be taken to the linked cell
steps once again carefully:
1. Go to Cell A1 in Sheet1
2. Click 'Trace Dependents'
3. An Arrow will appear
4. Double Click on the starting point of Arrow
5. 'Go To Box' will open
6. Select the path in 'Go To Box'
7. Click 'Open'
8. U will be taken to the linked cell
Message likes :
1 times
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Is this income indian or foreign income?
- REGARDING GST ON COMMERICIAL PROPERTY
- 15ca /15cb whose income tax login? remitter or nri seller's login?
- GST on export of services and Input Credit
- TDS U/S. 194NF
- ITC temporary reversal and reclaim
- RCM applicability on Rent Paid by Registered Person to Unregistered Landlord for Residental Building
- Regarding Documentation & Compliances for Opening of Unit of Pvt Ltd.
- Applicable TDS rate for sale of property in Nov 2024
- Should I report my US salary for January, February, March in Schedule FA?
- Can a partnership firm become partner in a LLP ?
- Quiery in relation to GST liability in case of an advocate who has obtained GST registration.
- LAST YEAR 2022-23 ITC IN NEXT YEAR 2023-24 REPORITNG IN GSTR-9
- MIS MATCH OF INVOICE NUMBER
- IGST Credit-Show cause notice issued-confusion
- TDS on purchase of value vouchers for employees ?
- Issue of gst e invoice
- How to adjusted advances given or receipt
- Foreign vendor without PAN unable to to register due to non receipt of OTP on foreign number ?
- 133(6) DIN INVALID format error - ->WHERE TO REPLY 133(6) notice?
Trending Online Classes
CAclubindia
