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. Coul...
Zack Barresse
Apr 10, 2022Iron Contributor
The 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
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
joeemery
Apr 10, 2022Copper Contributor
Thanks 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
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
- joeemeryApr 10, 2022Copper ContributorFYI
I "Unmerged" cells and column A appeared.
IT's a mystery to me
Joe- Zack BarresseApr 10, 2022Iron ContributorMerging cells shouldn't prevent you from unhiding, that's strange. But, glad you got it fixed!