Results 1 to 9 of 9
Like Tree3Likes
  • 1 Post By collents
  • 1 Post By Bruce Hankins
  • 1 Post By collents

How to unhide column A

This is a discussion on How to unhide column A within the Excel Questions forums, part of the Question Forums category; I hid column A in my worksheet, I am having troble unhiding it...

  1. #1
    Board Regular
    Join Date
    Jan 2003
    Posts
    143

    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

    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
    13,946

    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

    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

    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

    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
    2

    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
    ChrisOK likes this.

  8. #8
    New Member
    Join Date
    Oct 2011
    Posts
    1

    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.
    ChrisOK likes this.

  9. #9
    New Member
    Join Date
    Feb 2010
    Location
    All over the world
    Posts
    2

    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!
    ChrisOK likes this.

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