Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Unhiding columns

22 views
Skip to first unread message

Anuj

unread,
May 18, 2007, 7:16:02 AM5/18/07
to
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

CLR

unread,
May 18, 2007, 7:33:01 AM5/18/07
to
I don't use XL2007, but the trouble might be that the sheet might be Protected.

Vaya con Dios,
Chuck, CABGx3

Anuj

unread,
May 18, 2007, 7:39:00 AM5/18/07
to
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

unread,
May 18, 2007, 7:54:01 AM5/18/07
to
Try Format > Columns > Unhide...............or maybe the column is not hidden
at all but only set to a very narrow column width........

CLR

unread,
May 18, 2007, 7:56:03 AM5/18/07
to
Try Format > Columns > Unhide...........or maybe the column is not really
hidden at all, but only set to a very narrow column width.......

Roger Govier

unread,
May 18, 2007, 7:59:48 AM5/18/07
to
Hi

Hiding and Unhiding columns can be achieved in the same way as XL2003.
Mark the range of columns>right click>Hide
Mark the columns either side of the hidden columns>right click>Unhide

If you want to go the route of Format>columns>Unhide, then in XL2007
Home tab>Cells group>Format>Hide & Unhide>choose Rows or Columns

--
Regards

Roger Govier


"Anuj" <An...@discussions.microsoft.com> wrote in message
news:03FA1477-7693-4BE0...@microsoft.com...

Anuj

unread,
May 18, 2007, 8:33:00 AM5/18/07
to

Thanks once again Roger ...

... Gosh ! that was stupid of me ....

I was looking under the View tab .. which has Hide and Unhide .. But I now
realize that this is for the entire workbook. Guess one will take some more
time to get familiar with XL2007 totally.

Incidentally the contextual right click after selecting multiple columns in
XL2007 does not seem to have Hide/Unhide option (XL 2003 had that).

Happy days are here again

Cheers

Anuj

Roger Govier

unread,
May 18, 2007, 9:15:13 AM5/18/07
to

>Incidentally the contextual right click after selecting multiple
>columns in
>XL2007 does not seem to have Hide/Unhide option (XL 2003 had that).

Are you sure?
It does for me. They are the last 2 items in the list Hide and Unhide
--
Regards

Roger Govier


"Anuj" <An...@discussions.microsoft.com> wrote in message

news:C59880B0-7B94-45A9...@microsoft.com...

0 new messages