How to keep Column headers with Autofilter & Freeze Panes
Make sure you apply the freeze panes with all the rows showing.
Rich D wrote:
I have a spreadsheet (Excel 2003) with which I use Autofilter a lot. I also
freeze the panes just below the column headers (titles). With this in place,
once I scroll down past the first page, my column headers disappear. I've
tried putting in blank rows & moving the row on which I place the cursor when
setting up the autofilter. What can I do about this problem? thanks for
your help.
--
Rich D
Armstrong Custom Homes
Redmond
--
Dave Peterson
|