Excel Help: tracing formulas between cells within workbopok

A

ana

I want to click into a cell with a formula and be automatically directed to
that link. For example, if In Sheet 1, cell A1 I enter ='Sheet 2'!A1, how do
I link the formulas such that when I click into the first Sheet 1, cell, I am
automatically directed to the linked cell A1 in Sheet 2?

Thanks!
Ana
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Worksheet linking 2
Auto Change Formulas - Please Help. 2
Excel IF Formulas 2
Linking cell ranges between rows and columns 1
Vlookup and return sheet name also 2
Linking cells on different sheets within a workbook. 1
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
sheet name in cell that is used by other formulas 3

Top