How to print a excel sheet with a filter

Hi Michael

Thank you for your question. I have tried to recreate the problem you are experiencing and the filtering and printing seems to be working as expected for me (ie the filtered rows are all adjacent to each other rather than spread over multiple pages).

There are a couple of things worth checking in your sheet:

Has a print area been set that is forcing more cells to be printed than you need? Take a look at the Page Layout tab and choose Print Area > Clear Print Area

The other place to check is if there are any unnecessary page breaks in your sheet. You can see page breaks by going to the View Ribbon then choose Page Break Preview (you may need to click OK to clear the introductory message dialogue box). The dotted blue lines on the page are automatically placed by Excel and indicate where the page breaks fall. You can click on these lines and drag them to re-position them to where the breaks should be. Drag any extra page-breaks out into the grey area surrounding your sheet to remove them.

Let me know if either of these helps in any way or if you are still having problems and I will look into this further for you.

Kind regards,

Andrew