Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatically show cell references of formulas
when i open my spreadsheet and move around various cells, there are no
colored outlines to show cell references in formulas. I thought I remember seeing it before; maybe I accidently unchecked an option. I can double-click the desired cell to show the colored outlined references, but I don't want to have to double click every one, just to randomly move around the sheet. Also, I can use the ctrl+~ option but don't want to use that because it shows the formulas; Is there an option to show the colored outline of cell references without double-clicking or showing formula view. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatically show cell references of formulas
Maybe a close fit ..
Select a formula cell which houses a ref to more than a single precedent, eg: =SUM(B1:B4) then click Tools Formula Auditing Trace Precedents -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "newbie" wrote: when i open my spreadsheet and move around various cells, there are no colored outlines to show cell references in formulas. I thought I remember seeing it before; maybe I accidently unchecked an option. I can double-click the desired cell to show the colored outlined references, but I don't want to have to double click every one, just to randomly move around the sheet. Also, I can use the ctrl+~ option but don't want to use that because it shows the formulas; Is there an option to show the colored outline of cell references without double-clicking or showing formula view. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
double click cell to show formula references | Excel Discussion (Misc queries) | |||
how do I change cell references automatically in formulas | Charts and Charting in Excel | |||
Formula automatically changing cell references | Excel Worksheet Functions | |||
Formulas within Cell References | Excel Discussion (Misc queries) | |||
Changing cell references automatically | New Users to Excel |