How to reach at the source of the formula

  • Thread starter Thread starter Ahmad
  • Start date Start date
A

Ahmad

HI
IF I HAVE A FORMULA IN A1 CELL OF SHEET1 I.E "=SUM(SHEET2!B3:B40)", HOW CAN
I GO TO THAT RANGE WITH OUT USING SHEET TAB WITH THE MOUSE OR alt+page down.

AHMAD
 
You can click "Trace precedent" on the Formula Auditing toolbar, then
double-click on the dotted arrow line (leading from the little sheet icon) to
surface the "Go To" dialog. Then just double-click on the range in the
dialog's window and it'll zap you straight to that source range.

If the above helped you in any/some way, pl press the YES button below

p/s: Don't use all caps in your post. Hard to read & is considered impolite
nettiquette.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
 
If you disable Tools>Options>Edit "edit directly in cell" a double-click on
the cell will take you to the range.


Gord Dibben MS Excel MVP
 
Thanks Max.

The minor inconvenience of having to edit in the formula bar arises but I
rarely edit in cell so OK for me.

I prefer F2


Gord
 
Back
Top