How can I reveal hidden column and row headings on screen?
 

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.

How can I reveal hidden column and row headings on screen?
 

Hi Caroline

Go to Tools Option and check the box for Row and Column headings

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=521003

How can I reveal hidden column and row headings on screen?
 

In Tools - Options, select the "View" tab
In the middle near the bottom there should be a "Row & Column Headers"
option, if you tick that it should solve your problems.

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