Try Format Columns Unhide...............or maybe the column is not hidden
at all but only set to a very narrow column width........

Vaya con Dios,
Chuck, CABGx3



"Anuj" wrote:

Thanks .. but no the sheet is not protected- Moreover I am able to hide,
split, freeze - do whatever else I want to except unhide

"CLR" wrote:

I don't use XL2007, but the trouble might be that the sheet might be Protected.

Vaya con Dios,
Chuck, CABGx3




"Anuj" wrote:

This sounds basic but I am stuck.

It used to be so easy in Office XP to unhide columns - Just select across
and click unhide.

In Excel 2007 when I select across the hidden columns , the unhide button
remains 'grey' (inactive). How do I unhide? - I am however able to manually
drag the column header and increase the column width of the hidden columns,
but would like a more direct way