Column A won't unhide

[Liberty42]

Column A won't unhide and I have no idea when/how it was hidden in the first place. (Working with a cat on my lap may have something to do with it

Thanks in advance, I need to publish this doc asap. Uploading sample, the actual doc is 18 pages.

[sandy666]

select

unhide.png

then right click on any header of column and choose unhide

[TMS]

Click on the little black triangle to the left of the column letters and above the row numbers. Then click on Format | Hide & Unhide | Unhide Columns. Done.

[Liberty42]

Doesn't work. Is it my copy of excel?
As an experiment I used my Book1 sample to hide another column and unhide it. Hide works fine. Unhide does nothing.

HELP!!!

[sandy666]

check again

unh.png

[TMS]

What doesn't work. Sandy's approach or mine? It works with the sample file (So does Sandy's but it's a bit trickier to get the handle for column just A).

Or, you can press F5, select any cell in column A, say A1, then Format | Hide & Unhide | Unhide Columns.

[Liberty42]

OK this may sound like a newbie question even though I was once considered an excel expert, but where the heck is FORMAT? What happened to it? Where did it go?

[TMS]

Unhide does nothing.

Yes, it does. You just have to work out how to select the hidden column. If it's in the middle somewhere, it's easy because you can select the columns on both sides.

[Liberty42]

Found Format. Finally. It worked this time. Thank you SOOOOOO much.

[sandy666]

https://support.microsoft.com/en-us/...ide%20Columns.

[TMS]

You're welcome.



If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.