CRTL [

J

Jill

HI, use CTRL [ to find cells that are used in a formula, across sheets and
workbooks. Trying to then get back to original cell but CTRL ] only seems to
work in the same sheet, not across workbooks. Can anyone help please?
 
L

Luke M

Under View - Toolbars, select formula auditing. Now, you can click the "show
precedents" button to have XL trace back. If precedent is in another
workbook, an icon of a table will apear. Double click on icon to bring up the
Go To dialogue. You can then use this to go straight to the cell in the other
workbook. NOTE: Workbook must be open. You can't force XL to open another
workbook via formula auditing.
 
H

Homey

do what i tell you yesterday. it not hard for even not smart people.
-press F5 key - goto box popup but do not pick any thing.
-press enter key
and you back
 
Top