software

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 gt; Option and check the box for Row and Column headings

Ed--
EdMac
------------------------------------------------------------------------
EdMac's Profile: www.excelforum.com/member.php...oamp;userid=30736
View this thread: www.excelforum.com/showthread...hreadid=521003In Tools -gt; Options, select the quot;Viewquot; tab
In the middle near the bottom there should be a quot;Row amp; Column Headersquot;
option, if you tick that it should solve your problems.

In article gt;, =?Utf-8?B?
Q2Fyb2xpbmUgRQ==?= lt;Caroline gt; says...
gt; My colleague has hidden the column and row headings in a spreadsheet and I
gt; don't know how to reverse this.
gt; I need to highlight columns to unhide other hiden columns but cannot.
gt; The worksheet is not protected.
gt;
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