Page set up probem in Excel 2002

  Darl Lord 10:24 08 Jun 2005

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 2005

..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 2005
  pauldonovan 15:35 08 Jun 2005

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

  Darl Lord 15:37 08 Jun 2005

Cheers guys. I've cracked it now.

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

Elsewhere on IDG sites

The Evil Within 2 review-in-progress

Photoshop CC 2018 released with new Curvature Pen and better brush tools

Camera tips to take better iPhone photos

Les meilleures applications de covoiturage 2017