I use Excel a lot (2000 and 2003) and frequently create long formulas which
have 4 or more rows. When I have the size of my workbook maximized, these
formulas hide my column headings (A,B,C,etc.). When formulas become more
than 1 row, the size of the maximized window should always modify so that a
user can always see the column references while editing. Is there a way to
do this without constantly having to re-size my active workbook window (i.e.
taking it off maximized)? It is so aggravating ...

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Have you considered breaking the formulas down into smaller formulas in
different cells and Consolidating (for lack of a better term) into the
original cell. Or is that not feasible?


"MadMurr" wrote:

I use Excel a lot (2000 and 2003) and frequently create long formulas which
have 4 or more rows. When I have the size of my workbook maximized, these
formulas hide my column headings (A,B,C,etc.). When formulas become more
than 1 row, the size of the maximized window should always modify so that a
user can always see the column references while editing. Is there a way to
do this without constantly having to re-size my active workbook window (i.e.
taking it off maximized)? It is so aggravating ...

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

It would probably require a substantial reworking of the layout of the
workbook sheets to accomodate that but it is a possibility. I guess I would
rather have Microsoft add the maximized scalability into future versions - I
am sure there must be lots of users who run into the same problem.

"Peter Ellis" wrote:

Have you considered breaking the formulas down into smaller formulas in
different cells and Consolidating (for lack of a better term) into the
original cell. Or is that not feasible?


"MadMurr" wrote:

I use Excel a lot (2000 and 2003) and frequently create long formulas which
have 4 or more rows. When I have the size of my workbook maximized, these
formulas hide my column headings (A,B,C,etc.). When formulas become more
than 1 row, the size of the maximized window should always modify so that a
user can always see the column references while editing. Is there a way to
do this without constantly having to re-size my active workbook window (i.e.
taking it off maximized)? It is so aggravating ...

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc