x404.co.uk
http://x404.co.uk/forum/

Excel - view formula cells
http://x404.co.uk/forum/viewtopic.php?f=4&t=1460		 Page 1 of 1
Author:  Fogmeister [ Thu Jun 25, 2009 3:05 pm ]
Post subject:  Excel - view formula cells
When you are editing a formula cell in Excel, it puts coloured outlines of all the cells/ranges referred to in the formula.

Is it possible to have this view enabled just by clicking on the forumla cell? i.e. move the cursor to that cell and the referenced cells get outlined, move out of the cell (using the aroow keys/tab/enter/etc...) and the cells lose their coloured outlines.
Author:  AlunD [ Thu Jun 25, 2009 3:14 pm ]
Post subject:  Re: Excel - view formula cells
Regrettably not that I'm aware of.
Author:  koli [ Thu Jun 25, 2009 6:08 pm ]
Post subject:  Re: Excel - view formula cells
Closest thing I know to do what you need is "formula auditing".

I don't know where to find it as I don't have Office 2003 handy but shortcuts are Alt+T+U+ ?
? = "T" for precedents
? = "A" to remove all audit trails

You can also find "dependants" but I don't use that shortcut so I can't tell you right now.

Pressing F2 will enable you to edit the cell and will higlight precedent cells too.

I am sorry if I am insulting your intelligence but I know people who use Excel daily and can't even use "Find" function :roll:
Page 1 of 1 All times are UTC
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/