Print area in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1255622%22%20slang%3D%22en-US%22%3EPrint%20area%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1255622%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Guys%3C%2FP%3E%3CP%3EI%20have%20a%20worksheet%20that%20actually%20has%2021%20A4%20pages%20on%20it%20(all%20visible%20on%20one%20sheet).%20I've%20tried%20printing%20them%20individually%20by%20setting%2Fadding%20print%20areas%20but%20I%20still%20get%20A4%20pages%20with%20some%20of%20the%20next%20pages%20data%20on%20it.%20Is%20there%20any%20way%20of%20ensuring%20each%20page%20prints%20separately%3F%20I%20realise%20I%20can%20highlight%20each%20area%20and%20print%20individually%20but%20I%20have%20'many'%20speadsheets%20with%20the%20same%20problem%20so%20really%20want%20to%20know%20how%20to%20do%20this%20properly%3C%2FP%3E%3CP%3EI've%20attached%20an%20example.%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20great%3C%2FP%3E%3CP%3EYours%20in%20anticipation%3C%2FP%3E%3CP%3ESteve30%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1255622%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

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