Print area in Excel

Copper Contributor

Hi Guys

I have a worksheet that actually has 21 A4 pages on it (all visible on one sheet). I've tried printing them individually by setting/adding print areas but I still get A4 pages with some of the next pages data on it. Is there any way of ensuring each page prints separately? I realise I can highlight each area and print individually but I have 'many' speadsheets with the same problem so really want to know how to do this properly

I've attached an example.

Any help would be great

Yours in anticipation

Steve30

0 Replies