| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to reach at the source of the formula
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 --- "Ahmad" wrote: 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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I reach a web site with web address | Excel Discussion (Misc queries) | |||
| short cut to reach a sheet | Excel Discussion (Misc queries) | |||
| Data labels out of reach | Charts and Charting in Excel | |||
| Sum of row untill you reach a certain point (2) | Excel Discussion (Misc queries) | |||
| Sum of row until you reach a certain amount | Excel Discussion (Misc queries) | |||
Threaded Mode
