Consulting

Results 1 to 6 of 6

Thread: How to Recover Columns That Are Off the Sheet

  1. #1

    How to Recover Columns That Are Off the Sheet

    I'm not sure what happened, but I just noticed that on one of my worksheets the first column displayed is "AD". I tried a bunch of things to get the columns "A" through "AC" to display, but (sigh!) nothing worked. Any suggestions about how to shift everything right so I can see the covered columns? I tried a GoTo "A1". I tried to unhide them. Neither worked. Weird ... very weird.

  2. #2
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    Try this:

    Ctrl + A
    Right click on a column and select Unhide.

  3. #3
    Hey, Jake, I did that several times, and (sigh) it didn't work. I had this problem once a long time ago, and for the life of me I can't remember what I did. Fortunately this isn't an important sheet, so I guess I'll just recreate it. But I sure would like to know a fix. Thanx for the reply.

  4. #4
    VBAX Expert
    Joined
    Feb 2005
    Posts
    929
    Location
    Quote Originally Posted by Cyberdude
    Hey, Jake, I did that several times, and (sigh) it didn't work. I had this problem once a long time ago, and for the life of me I can't remember what I did. Fortunately this isn't an important sheet, so I guess I'll just recreate it. But I sure would like to know a fix. Thanx for the reply.
    can you repost with the workbook attached.?
    "It's not just the due date that's important, it's also the do date" [MWE]

    When your problem has been resolved, mark the thread SOLVED by clicking on the Thread Tools dropdown menu at the top of the thread.

  5. #5
    Sorry I didn't reply sooner, but the forum input editor sometimes won't let me type anything, and yesterday was one of those days.
    Thanx to all of you for your suggestions. I have discovered the problem. I had frozen (freezed??) the window panes on this sheet and then forgot I did it. When I unfroze (defrosted??) the panes ... Voila! ... the missing columns presented themselves to me. So I'm back in business.

  6. #6
    VBAX Expert
    Joined
    Feb 2005
    Posts
    929
    Location
    Quote Originally Posted by Cyberdude
    Sorry I didn't reply sooner, but the forum input editor sometimes won't let me type anything, and yesterday was one of those days.
    Thanx to all of you for your suggestions. I have discovered the problem. I had frozen (freezed??) the window panes on this sheet and then forgot I did it. When I unfroze (defrosted??) the panes ... Voila! ... the missing columns presented themselves to me. So I'm back in business.
    I think you should send MS a note about including the defrost menu pick in future version of Excel
    "It's not just the due date that's important, it's also the do date" [MWE]

    When your problem has been resolved, mark the thread SOLVED by clicking on the Thread Tools dropdown menu at the top of the thread.

Posting Permissions

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