Double click on cell with formula

[abc]

When double clicking on a cell with a formula, it's not easy to see what
cells the formula is using. In Excel for Windows, it is highlighted
very clearly but in Mac, it seems the cells are highlighted in white
and the line number is dark grey. Please can someone advise a better
way of viewing formula visually with colours?

 

[CyberTaz]

I can't tell from you description exactly what the problem is nor do you
indicate your version & update level for Excel. In any event, what I see
here in Excel 2008 is basically the same as in Excel 2003 on the PC -- the
cell references are color coded & the referenced cells are bordered by the
corresponding color.

There's nothing available to change the highlight color of the Row & Column
Headings if that's what you're referring to. However, I've found that the
Formula Bar is a much better place to do anything relative to a cell's
content rather than attempting to view or edit in the cell. The Name Box at
the left end of the Formula Bar explicitly identifies the reference of the
active cell & the content is clearly readable, editable & clear of
surrounding distraction in the Formula Bar's editing field.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[TheRedOak]

A different way of seeing visibly which cells are reffered to is by double-clicking the cell that contains the formula. When you do this, all the referenced cells become highlighte and can then use the TAB key to toggle through each referenced cell. In order to use this technique you must go into Excel preferences and deselect "edit directly in cell".

This has always been the most efficient way for my pea-sized brain to see what is going on within the spreadsheet. Just depends how you like to work.

Bobby

 

[abc]

A different way of seeing visibly which cells are reffered to is by
double-clicking the cell that contains the formula. When you do this,
all the referenced cells become highlighte and can then use the TAB key
to toggle through each referenced cell. In order to use this technique
you must go into Excel preferences and deselect "edit directly in cell".

This has always been the most efficient way for my pea-sized brain to
see what is going on within the spreadsheet. Just depends how you like
to work.

Bobby

Thanks, that's worked for me.