scalable headings in Microsoft Excel when editing long formulas

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