I have a spreadsheet that is giving me a problem with unhiding a column. I keep Column B hidden as a matter of course, and use it to calculate some clock intervals that are then accessed by printing Bxxxx. Now, Bxxxx is still available to the program as it is printed during the normal course of spreadsheet use. However, I suddenly cannot unhide it by the normal method of selecting column A and C and choosing “unhide” from the menu. Everything else looks OK, but B remains hidden no matter what I do. Any ideas among the Excel wizards here?
The width of column B may have shrunk down to 0.08 (one pixel). When you highlight column A, then Shift+right-arrow once, does column C get highlighted? If not, then while columns A & B are highlighted, change the width of column A so that both column A & B will resize their columns to match each other.
Thanks, Monimonika. I hadn’t thought of that. I increased the zoom level until only about three columns were shown , and column B showed up as a very narrow double line. Wonder how that happened in the first place.
Once in a while Excel seems to be beset by poltergeists. Funny little buggers.
Another trick is to use Excel’s “Go To” command (Ctrl-G). It’s usually used to go to a single cell, but you can enter a range of cells, or rows, or columns. When I’ve hidden rows and can’t unhide them, I type ctrl-G, then put, for example, A:C (which selects those entire columns). Right-click and select unhide, and the column is back!
Typo Knig, did you read the OP to the end? How’s that different from what Daylate had already tried?
Daylate,
Glad to have helped. 
I assumed the failed selection attempt was by clicking and dragging. Using the “Go To” function is entirely keyboard-based, and lets you “go to” (i.e., select) hidden cells or rows or columns by typing in the address or row range or column range.