Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gazzr
 
Posts: n/a
Default Information hidden when I press F2


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   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Information hidden when I press F2

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy without Hidden Cols - How abrogard Excel Discussion (Misc queries) 1 July 15th 05 07:54 AM
Hidden Columns in Shared Workbooks Rotary Excel Discussion (Misc queries) 1 July 9th 05 12:28 AM
How to "ignore" hidden columns? xpucto Excel Discussion (Misc queries) 2 May 26th 05 02:08 PM
Prevent Hidden Column data from being copied/pasted? Jugglertwo Excel Discussion (Misc queries) 2 April 9th 05 12:45 PM
hidden rows & columns slow file open Simon Shaw Excel Discussion (Misc queries) 0 April 5th 05 12:21 AM


All times are GMT +1. The time now is 01:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"