View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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