Page set up probem in Excel 2002

  Darl Lord 10:24 08 Jun 05

I have a problem with a several workbooks containing multiple worksheets. I want to set up printer output in such a way as each page prints out on a separate page. This is easy enough, but is there a way of applying one-sided printing to each worksheet en masse? I've tried selecting all worksheets and going through Page Setup/Page (tab)/Options and applying changes there, but can't the changes to apply to each worksheet in the workbook. Any ideas, coz this is proving to be a real pain in the arse?

  pauldonovan 10:58 08 Jun 05

..I did a quick search on Google for:

"excel apply page setup to all pages in workbook"

and got some results including:

click here;en-us;Q213257

that may well do what you need.

  VoG II 14:51 08 Jun 05
  pauldonovan 15:35 08 Jun 05

..always wondered why you do that tinurl thing as my links normally work...but now I know :)

  Darl Lord 15:37 08 Jun 05

Cheers guys. I've cracked it now.

This thread is now locked and can not be replied to.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation technologies coming to Siggraph 2017

iPad Pro 12.9 vs Surface Pro 5