How to automatically jump to the formulas origin

  • Thread starter Thread starter Phoenix
  • Start date Start date
P

Phoenix

If i have a formula in Sheet1, A1. This formula refers to a result fro
Sheet2, A1. Can I (with double-clicking or something) in Sheet1, A
automatically be brought to Sheet2, A1 to tell me the
formulas origin ? :confused
 
How about if you define a name at Sheet2, A1... then you
can insert a hyperlink on Sheet 1, A1 to go to
the "bookmark" of your defined name.

Just by single clicking you go to the source you specified.

Cheers!
 
Phoenix

Tools>Options>Edit. Uncheck "edit directly in cell".

Double-click on Sheet1 A1 will now take you to Sheet2 A1

Gord Dibben Excel MVP
 

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

Excel Moving data to sheet2 from sheet1 0
EXCEL - IF(IFERROR(VLOOKUP question 0
bookkeeping-payment confirmation 7
Fill formula down for cells 74 rows apart 3
A formula that autofills by trend rather than linear 1
Lookup and count in the same formula 1
counting how many of the same numbers 1
Hyperlink via indirect cell reference 8

Back
Top