Filtering data

L

Louise

HI all

How do I set up an auto-filter so when the data is
filtered, you can still see the column headings at the
top. I have done this before but can't remember how!!
I'm using Office XP.

Thank you.
Louise.
 
A

A.W.J. Ales

Louise,

Insert an empty ros above your columnheading and select the whole area
(empty row, columnheadings, data) and set autofilter.

(In this way however the columnheading becomes part of your data).

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
R

Roger Govier

Hi Louise

One way would be to increase the height of the row containing your headings
by right clicking on the row number, and setting height to say 25 and then
format that row with Format=>Cells=Aligment=>Vertical=>Top
 
Top