Sep 10 2022 04:52 PM
I have inadvertently hidden column A in a spreadsheet. I'm an experienced Excel user and I followed all the suggestions given in the help material but I still cannot unhide it. I'm at a loss for what to do.
Sep 11 2022 08:58 AM
Thanks for your response, but, that is one of the first things I tried after looking for a solution. I also did a GO TO A1, then did a Cell Format/Invisibillty and clicked Unhide columns. That didn't work either. This seems to defy the conventional solutions offered in the Help material. I can't grab it to widen manually either. Any other suggestions?
Sep 11 2022 09:15 AM
Sep 11 2022 09:59 AM - edited Sep 11 2022 10:03 AM
The column might not be hidden just has 0 width. In this case use the box above the 1 and to the left of the B like in the image provided and that would select all rows and columns, then move right to any column header, say column C and right-mouse-click and choose Column Width a bit at the end of the context menu, and set the column width say to 8 and then you can reset the column width to match what you had.
Also, if you use F5 Goto dialog will appear and then type A1 in the Reference box and then move the mouse to the edge and right-mouse click and choose Column Width.
I also can say that if you select Column B and then ever slightly move to the left that would select Column A as well, then right-mouse click and choose Column Width.
Both these techniques require good dexterity with the mouse, and the first is simpler from that stand point.
You can also use VBA with some simple commands used in the Immediate Window can make that happen.
Hope this helps.
Sep 11 2022 10:26 AM