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.

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

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.

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