View Full Version : Retrieving hidden columns

02-16-2007, 01:58 PM
Hi All,

I prepared an Excel spreadsheet with data in columns A to D. Later on data was added in the columns E to AZ by others. When the spreadsheet was returned to me, I am not able to see the columns A to D. The spreadsheet STARTS from column E. I tried the operations in the Window menu like "Freeze/Unfreeze" "Split/Remove split" etc. I checked in the Edit menu to see whether I can "undo" something. If someone has deleted the columns A to D, the spreadsheet should still start from col A.

I can see the horizontal scroll bar showing a gap with column E at the start, but by manually bringing it to the extreme left does not show the columns A to D.

Can someone please advise me what could be the problem and what I should do to retrieve my data?
Thanks in advance

02-16-2007, 02:51 PM
Range("A:D").EntireColumn.Hidden = False

02-16-2007, 04:02 PM
Thanks Charlize, that did the trick.

- Krishna

02-16-2007, 04:09 PM
A non-VBA solution.
Select the first visible column and drag the cursor to the left. This selects the hidden columns as well. You can then fix them with Format/Columns/Unhide.