Forum Discussion
joeemery
Apr 10, 2022Copper Contributor
Excel
Column A appears to be hidden. I have used the help directions to no avail. In addition when I go to B1 the name box above it shows "A" instead of B1. This may be associated with my problem.
Could this be something other than a hidden column? Or do you have another solution to unhide the 1st column?
7 Replies
- Patrick2788Silver Contributor
You may use the Name box to navigate to A1 (or any cell within Column A). From there, it's a matter of going to Home | Format | Column Width - hidden columns are set to 0. Set the column width to the standard 8.09.
Name box for reference:- Zack BarresseIron ContributorThe fix can be a little weird and non-intuitive. To unhide column A, or any set of columns on the far-left, select column B and, without letting go of your left mouse click, continue dragging to the left until you're over the left side of the column. Once selected you can let go of your mouse button. Then, right-click column B header (any selected column header, actually) and select Unhide.
The trick is to ensure you're selecting the hidden columns, which is difficult because, well, they're hidden. Another way would be to use the Name box to select the range. You need to be careful though, because you could name a range. Since "A" is a valid name for a range, you could actually name column B to a range name of "A". This would make things *very* confusing. If you were to use the Name box to select columns A through B, you would need to click in it and type "A:B" which is a valid range *reference*. If a reference is typed in that box it will go to, or select, that range if it can. Then you would right-click any selected column as described above and choose Unhide from the menu.
HTH- joeemeryCopper ContributorThanks Zack
I Tried this as per your instructions with no result. This is what makes me think there is another problem disguised as a hidden column. any thoughts?
Joe
- joeemeryCopper Contributor
- joeemeryCopper ContributorThanks Patrick2788 . I tried that and followed that with the visability/unhide. still no go.