Printing Column Names in Filtered report

[yellowcabguy]

Having a senior moment.

My column Names are in row three.

When I use a filter to get only certain records the column names are not appearing.

I went to page setup sheet and entered $3:$3 on the repeat line but I can't seem to get the column names to appear on my filtered report.

What am I doing wrong??


Thanks

 

[SydneyGeek]

Hi Yellowcabguy,

when you apply the filter, are the headings visible?

Denis

 

[yellowcabguy]

printing column names in report

When I apply the filter I am losing theh 3rd row which has the column names. I am getting row one which has some totel text in it adn can't seem to get Row 3 to appear.

 

[SydneyGeek]

OK, remove the filter. Then do this:

Select from A3 to the bottom right corner of the table.
Data > Filter > Autofilter.

It's an occupational hazard of having data above the table -- Excel assumes the you want to use the first row of the contiguous region for your headings, unless you specify otherwise by making a selection.

Denis

 

[yellowcabguy]

printing in filter mode

That works. Thanks a bunch