View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Tushar Mehta
 
Posts: n/a
Default How can I reveal hidden column and row headings on screen?

In article , ?B?
Q2Fyb2xpbmUgRQ==?= <Caroline says...
My colleague has hidden the column and row headings in a spreadsheet and I
don't know how to reverse this.
I need to highlight columns to unhide other hiden columns but cannot.
The worksheet is not protected.

Select the columns (or rows) that are visible. For example, if col. D is
hidden select C then SHIFT+select E. Now, right click and select Unhide.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions