Hiding Header Columns abc... in 2007
 

Is there a way to hide the header columns ABC etc but not hide the rows 123
etc?
In excel options, advanced, display for this wksheet, the check box is for
both rows and column headers but not for one or the other.

Hiding Header Columns abc... in 2007
 

Hi Debbiejj

You must hide both and add the numbers in column A and use Window Freeze Panes so column A is always visible

You can add a formula like this in column A
=Row()

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Debbiejj" wrote in message ...
Is there a way to hide the header columns ABC etc but not hide the rows 123
etc?
In excel options, advanced, display for this wksheet, the check box is for
both rows and column headers but not for one or the other.