Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts

    Cell Name display box size (Excel 2003)

    With reference to the display of Cell Names at the top left of a worksheet, how can I make this display box wider so as to be able to see all of longer cell names ?

    Help much appreciated

    Martin

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Cell Name display box size (Excel 2003)

    Hi Martin

    If you click the grey square at the very top left of the Excel "grid" between A and 1 it will highlight the whole sheet. Move you mouse to a point between the A and B so that the cursor changes to a East/West type and double click. This will automatically resize all columns.

    HTH
    Jerry

  3. #3
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts

    Re: Cell Name display box size (Excel 2003)

    Thanks Jerry, but I am not referring to a worksheet column/cell but to the box in which cell names are displayed.
    Martin

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Cell Name display box size (Excel 2003)

    Gotcha, sorry, I had to re-read your first question a couple of times to get it, try:

    Resize Excel Name Box with COM add-in

    Although set for XL2K I cannot see any reason it shouldn't work for 2K3
    Jerry

Posting Permissions

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