"Shane Devenshire" wrote:

Hi,

Choose Data, Filter, AutoFilter. Open the autofilter dropdown on any column
you want to look at and choose (blanks). You can print the results and the
filters don't show. To return to seeing everything just open the dropdown
and choose "all"
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

Great, it works almost exactly as I want.

(For some reason I never think of using Filter. In fact I have used it
unknowingly - in running Word Mailmerges from my Excel database!)

The thing about getting this sort of help is that it always raises more
demands. In this case I am producing exception reports that I need to
distinguish from the normal complete printout of the database. So when
Autofilter is in effect:

(1) Can the filter conditions be automatically shown in the print header?

(2) Can certain groups of columns be omitted without having to hide each one
individually?