+ Reply to Thread
Results 1 to 3 of 3

scalable headings in Microsoft Excel when editing long formulas

  1. #1
    MadMurr
    Guest

    scalable headings in Microsoft Excel when editing long formulas

    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

  2. #2
    Peter Ellis
    Guest

    RE: 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


  3. #3
    MadMurr
    Guest

    RE: scalable headings in Microsoft Excel when editing long formula

    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


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1