View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
newbie newbie is offline
external usenet poster
 
Posts: 137
Default 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.