| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to keep Column headers with Autofilter & Freeze Panes
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to keep Column headers with Autofilter & Freeze Panes
Dave,
Thanks for responding. Unless I'm doing something wron, however, when I apply Autofilter to the column header (that's right, isn't it?), the actual column headers disappear leaving just the Autofilter arrows for the columns. -- Rich D Armstrong Custom Homes Redmond "Dave Peterson" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to keep Column headers with Autofilter & Freeze Panes
What row are your headers in?
What row contains the arrows for the autofilter? What row contains the start of the data? If you want to see rows 1 and 2 (say) then Show all the data (if you haven't already) select A1 (just to make sure it's visible) select A3 Window|Freeze panes Everything above the selected cell (A3) will be visible. Is something else happening when you do it? Rich D wrote: Dave, Thanks for responding. Unless I'm doing something wron, however, when I apply Autofilter to the column header (that's right, isn't it?), the actual column headers disappear leaving just the Autofilter arrows for the columns. -- Rich D Armstrong Custom Homes Redmond "Dave Peterson" wrote: 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 -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to keep Column headers with Autofilter & Freeze Panes
Dave,
My headers are in rows 1 & 2. I apply the autofilter (and the arrows appear) in row 2. Data starts in row 3. I did what you said. and all is fine until I put a criteria in one of the filters. Then when the data is actually filtered. I lose the 2nd (row 2)header row from view and the filter arrows appear in row 1. Under that appears the filtered data. -- Rich D Armstrong Custom Homes Redmond "Dave Peterson" wrote: What row are your headers in? What row contains the arrows for the autofilter? What row contains the start of the data? If you want to see rows 1 and 2 (say) then Show all the data (if you haven't already) select A1 (just to make sure it's visible) select A3 Window|Freeze panes Everything above the selected cell (A3) will be visible. Is something else happening when you do it? Rich D wrote: Dave, Thanks for responding. Unless I'm doing something wron, however, when I apply Autofilter to the column header (that's right, isn't it?), the actual column headers disappear leaving just the Autofilter arrows for the columns. -- Rich D Armstrong Custom Homes Redmond "Dave Peterson" wrote: 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 -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to keep Column headers with Autofilter & Freeze Panes
I don't have a guess. But this isn't normal behavior for excel.
If you do the same thing in a test worksheet in a new workbook, do you see the same behavior? Rich D wrote: Dave, My headers are in rows 1 & 2. I apply the autofilter (and the arrows appear) in row 2. Data starts in row 3. I did what you said. and all is fine until I put a criteria in one of the filters. Then when the data is actually filtered. I lose the 2nd (row 2)header row from view and the filter arrows appear in row 1. Under that appears the filtered data. -- Rich D Armstrong Custom Homes Redmond "Dave Peterson" wrote: What row are your headers in? What row contains the arrows for the autofilter? What row contains the start of the data? If you want to see rows 1 and 2 (say) then Show all the data (if you haven't already) select A1 (just to make sure it's visible) select A3 Window|Freeze panes Everything above the selected cell (A3) will be visible. Is something else happening when you do it? Rich D wrote: Dave, Thanks for responding. Unless I'm doing something wron, however, when I apply Autofilter to the column header (that's right, isn't it?), the actual column headers disappear leaving just the Autofilter arrows for the columns. -- Rich D Armstrong Custom Homes Redmond "Dave Peterson" wrote: 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 -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 freeze panes won't freeze top row only | Excel Discussion (Misc queries) | |||
| Freeze Panes | Setting up and Configuration of Excel | |||
| Freeze panes | Excel Discussion (Misc queries) | |||
| How can I print the column headers in a freeze pane on all pag | Excel Discussion (Misc queries) | |||
| Freeze panes | Excel Discussion (Misc queries) | |||
Hybrid Mode
