Categories: Sheets : Report an issue :

Cannot unhide column A in Google spreadsheet

Showing 1-21 of 21 messages
Cannot unhide column A in Google spreadsheet jimmy's shedd 3/5/12 2:07 PM
Several people seem to have had the same problem, yet this problem still exists. I have tried every suggestion, none of which work on Column A. If this can't be fixed, I would think you could at least warn us that Column A shouldn't be hidden.
Re: Cannot unhide column A in Google spreadsheet MarinusP 3/5/12 2:46 PM
Hi

Please share a spreadsheet with us where the problem occurs, so that we can see if we can make column A visible.
Re: Cannot unhide column A in Google spreadsheet cdegger 3/16/12 11:31 AM
Agreed, they should fix this issue or warn against hiding first and last columns. fwiw I resolved it by downloading the spreadsheet, unhiding the column, and then uploading it again (you could cut and paste hidden content if others revisions have been made in the meantime).

MarinusP you can recreate this issue any time by hiding -- and being able to unhide -- the first and last columns in any spreadsheet.

Christine
Re: Cannot unhide column A in Google spreadsheet MarinusP 3/16/12 3:12 PM
Op vrijdag 16 maart 2012 19:31:06 UTC+1 schreef cdegger het volgende:
MarinusP you can recreate this issue any time by hiding -- and being able to unhide -- the first and last columns in any spreadsheet.

Christine

Hi

Would you please share an example spreadsheet with us where the problem occurs?

I have tried it myself to hide and unhide column A: No problem at all! 
Re: Cannot unhide column A in Google spreadsheet red herring 3/21/12 12:47 PM
Just had the same problem. Make sure you unfreeze any rows or columns. You cant unhide a column that's behind a frozen column. I'm guessing vice versa for rows
Re: Cannot unhide column A in Google spreadsheet mazlo 4/4/12 5:54 PM
I have it too. It's not very clear how to unfreeze the header row.  I give this a black mark against G Docs usability. There are several..
Re: Cannot unhide column A in Google spreadsheet MarinusP 4/5/12 1:48 AM
Op donderdag 5 april 2012 02:54:23 UTC+2 schreef mazlo het volgende:
I have it too. It's not very clear how to unfreeze the header row.  I give this a black mark against G Docs usability. There are several..

Hi

Menu: View > Freeze rows > No frozen rows

Also it's on the Help-pages.

So... what do you you suggest how to make it more clear?


Re: Cannot unhide column A in Google spreadsheet jill17 4/15/12 9:21 AM
I also can't unhide column A. the spreadsheet has private info in it, so i don't want to upload it. i don't see an icon to click on. could you upload a screenshot showing me where to find it? thx 
Re: Cannot unhide column A in Google spreadsheet dziegman 4/15/12 9:54 AM
Here's one!

Hope this helps!

dziegman
Re: Cannot unhide column A in Google spreadsheet MarinusP 4/15/12 10:33 AM
Hi

Take a look at the attached picture. At the left side of column-header B, you see that small triangle. Click on it to make column A visible.
Re: Cannot unhide column A in Google spreadsheet jill17 4/15/12 12:27 PM
thank you for the screenshot! unfortunately, the little triangle is greyed out and clicking on it didn't help. then i got to thinking... perhaps it was because column B was frozen. so i unfroze column B and was then able to unhide column A. perhaps this is an important thing to note in your faqs and help documentation! thank you. jill
Re: Cannot unhide column A in Google spreadsheet MarinusP 4/15/12 12:36 PM
Hi

You're welcome!

Op zondag 15 april 2012 21:27:30 UTC+2 schreef jill17 het volgende:
 perhaps this is an important thing to note in your faqs and help documentation! 

Good idea. Let's hope a TC will send it through to Google.
Re: Cannot unhide column A in Google spreadsheet DMarx 6/5/12 7:36 AM
I was stuck on this and had been using the thick freeze bar column in the actual spreadsheet UI to "unfreeze" everything and still not seeing the triangle to unhide - it was frustrating.

I then followed @marinus suggestion to use the view -> freeze rows -> no frozen (& then also with columns) and the triangle came back!!
Re: Cannot unhide column A in Google spreadsheet Jakub Solak 1/24/13 2:52 AM
I had the same problem. My workaround that did the trick in my case was to duplicate the Sheet. Duplicated sheet somehow had column A visible. Seems like a bug anyway.
Re: Cannot unhide column A in Google spreadsheet SumZ 4/1/13 4:22 AM
Go to View-->freez Columns--->Click No Freeze Columns
At the left side of column-header B, you see that small arrow. Click on it to make column A visible.
Re: Cannot unhide column A in Google spreadsheet Christopher Hartwell of Auburn 9/12/13 11:24 AM
Unfreeze columns and rows first. Then an arrow appears to the left of "B" and click it. Column A will reappear. 

Chris 


Re: Cannot unhide column A in Google spreadsheet GadiSh 10/9/13 1:41 PM
Yay - that solved it. Thanks. 
Google -- I just spent 5 min on one of the most trivial of tasks. You should really fix it.
Re: Cannot unhide column A in Google spreadsheet GadiSh 10/9/13 1:40 PM
Re: Cannot unhide column A in Google spreadsheet Rick Jelovsek 12/22/13 11:27 AM
When you hit the down arrow icon in column A to hide, column A is hidden. But when you goto unhide column A you are supposed to hit the right arrow icon in column B. When I do this, however, a "hand" (I think "move") icon hides the right arrow in column B and you cannot unhide the column A. I found that if I go click to the left of column B, the "hand" icon disappears and I can now see the right arrow icon in column B to click on. That right arrow icon click then "unhides" coulmn A

Re: Cannot unhide column A in Google spreadsheet BabyStrabes23 1/2/14 8:00 AM
There is a little > arrow on the left side of column B. hover or click on it and it will unhide column A...then resize the cell width.
Re: Cannot unhide column A in Google spreadsheet Marcus Laing 3/19/14 7:21 AM
Problem solved!
When Col A is hidden, there's a tiny wee arrow thing in Col B's header, to the left of the letter B. Click it and see what happens...
More topics »