Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CRTL [
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? -- Jill |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
CRTL [
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. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Jill" wrote: 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? -- Jill |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
CRTL [
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 "Jill" wrote in message ... 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? -- Jill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Crtl+Z reassigned by muppet - cannot find to fix | Excel Discussion (Misc queries) | |||
What if copy crtl+c is not working it says cannot empty clipboard | Excel Discussion (Misc queries) | |||
CANT USE MY FAST KEYS EG CRTL+` TO FIND FORMULAS | Excel Worksheet Functions | |||
How do I prevent Crtl+End moving to a cleared cell? | Excel Worksheet Functions | |||
Crtl+V Problem in Excel | Excel Discussion (Misc queries) |