Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Sep 2005
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Columns lost; can't get to (2003)

    I have a lengthy spreadsheet which now seems to begin with Column C. I know I have material in A & B, but can't get the two columns to display. I have tried unfreezing the panes - but none were frozen. I have tried to unhide by selecting the entire spreadsheet, but they still do not display. I can do a search for a term which I know is in some, but not all, of the cells in one of the two missing columns, and my cursor will go each number of a row in which that term does appear in one of the non displaying columns, but I can't actually get to the columns themselves. Any help would be most appreciated!

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Columns lost; can't get to (2003)

    Have you tried clicking on the empty square at the intersection of the row and column lablels to select the entire sheet, the select Column from the Format menu, then click on Unhide in the flyout menu?
    Legare Coleman

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Columns lost; can't get to (2003)

    Hi,

    The method that Legare mentions, is the common way to unhide all columns...and this usually works...

    If all else fails, try this:
    1. Click in the name box (the drop down box at the left of the formula bar.)
    2. Type A1: B1 and press Enter (this will select cells A1 and B1, even if they are hidden.)
    3. Choose Format | Columns | Unhide.

    If this does not work, the only other thing that can be the cause is that the columns are visible, but extremely narrow in width. In this case, use steps 1 and 2 as listed above, but for step 3. Choose Format | Columns | Width and enter 10 and choose OK.

    The last alternative is to select the enter sheet, (press Ctrl + A) and then copy. Open a new blank sheet and choose paste, ensuring that you select match destination formatting from the smart tag.

    Cheers
    Regards,
    Rudi

  4. #4
    New Lounger
    Join Date
    Sep 2005
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Columns lost; can't get to (2003)

    Method 2 worked. Thank you so much!

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Columns lost; can't get to (2003)

    Great!!!

    What was method 2? Was it the width of the columns?
    Regards,
    Rudi

  6. #6
    New Lounger
    Join Date
    Sep 2005
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Columns lost; can't get to (2003)

    Yes, it was the width of the columns. I had tried Unhide, with no success. Somehow the columns had been narrowed to the extent that they were not, to my eyes, visible at all! You saved me a lot of work!

  7. #7
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Columns lost; can't get to (2003)

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Regards,
    Rudi

Posting Permissions

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