How to unhide column A

Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: How to unhide column A

  1. #1
    Board Regular
    Join Date
    Jan 2003
    Posts
    143
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How to unhide column A

     
    I hid column A in my worksheet, I am having troble unhiding it

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    There's a little square in between the A and 1 at the top left of the worksheet. Click on that to select all the cells and then go Format-Column-Unhide. Or put your mouse just to the right of it until it turns into a double line with arrows, then click and drag the column back out.

  3. #3
    MrExcel MVP
    Join Date
    May 2002
    Posts
    14,186
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    select column B. unhide. now select the left-most edge of col B & drag it to the right.

  4. #4
    New Member
    Join Date
    Oct 2002
    Posts
    42
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I did that once. All I did was slide the column width to the left of B to the right to reveal A

  5. #5
    New Member
    Join Date
    Feb 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I had this to happen to me once, the sheet was corupt, ended up making a new sheet then deleted the old one, a trick I also found was to highlight all col. then select to size them. That will open all hidden col.

  6. #6
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    Another option...

    In the name box, type A1, which should put you in the hidden A1 cell. Then, unhide the column.
    Bye,
    Jay

  7. #7
    New Member
    Join Date
    Feb 2010
    Location
    All over the world
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to unhide column A

    Sorry to reopen an old thread, but I just ran across the same problem but discovered why it might be happening (for some people).

    In my case the column wasn't hidden at all - I had "Freeze Panes" selected and didn't realise.

    So, before trying any of the above, check try unfreezing any frozen panes

  8. #8
    New Member
    Join Date
    Oct 2011
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to unhide column A

    Thanks for re-opening this thread. That was the fix for me! I was starting to go crazy until I scrolled down to your post.

  9. #9
    New Member
    Join Date
    Feb 2010
    Location
    All over the world
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to unhide column A

    Quote Originally Posted by Bruce Hankins View Post
    Thanks for re-opening this thread. That was the fix for me! I was starting to go crazy until I scrolled down to your post.
    Glad it helped!

  10. #10
    New Member
    Join Date
    Jul 2002
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to unhide column A

      
    Quote Originally Posted by collents View Post
    Sorry to reopen an old thread, but I just ran across the same problem but discovered why it might be happening (for some people).

    In my case the column wasn't hidden at all - I had "Freeze Panes" selected and didn't realise.

    So, before trying any of the above, check try unfreezing any frozen panes
    Thank you, thank you! That's exactly what my problem was!

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com