Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Hi All, This may not even be worthy of a post but if I have a long formula in a cell and hit F2 to look at what cells are being referenced the text of the formula gets in the way. As a result the referenced cells normally highlighted in the blues and yellows etc are 99% hidden. Is there anyway to change the way that the forumla is displayed when I press F2 so I can see clearly what cells I am referencing or should I stop complaining and get a life? Just noticed that one way round it is to resize the rows so I can see the boxes properly. Thanks Garry -- Gazzr ------------------------------------------------------------------------ Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075 View this thread: http://www.excelforum.com/showthread...hreadid=534431 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I make the worksheet window smaller and move it out of the way.
Gazzr wrote: Hi All, This may not even be worthy of a post but if I have a long formula in a cell and hit F2 to look at what cells are being referenced the text of the formula gets in the way. As a result the referenced cells normally highlighted in the blues and yellows etc are 99% hidden. Is there anyway to change the way that the forumla is displayed when I press F2 so I can see clearly what cells I am referencing or should I stop complaining and get a life? Just noticed that one way round it is to resize the rows so I can see the boxes properly. Thanks Garry -- Gazzr ------------------------------------------------------------------------ Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075 View this thread: http://www.excelforum.com/showthread...hreadid=534431 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy without Hidden Cols - How | Excel Discussion (Misc queries) | |||
Hidden Columns in Shared Workbooks | Excel Discussion (Misc queries) | |||
How to "ignore" hidden columns? | Excel Discussion (Misc queries) | |||
Prevent Hidden Column data from being copied/pasted? | Excel Discussion (Misc queries) | |||
hidden rows & columns slow file open | Excel Discussion (Misc queries) |