Excel question

  Mr Anderson 17:47 16 Jul 2003
Locked

Is it possible to copy the "Page Setup" settings to all of the worksheets?
I have four files with twelve worksheets per file and I want them to all have the same page settings

Using Excel 97 and XP

  Jester2K II 17:51 16 Jul 2003

You'll need to open each spreadsheet and do this for each one.

Click on the tab for sheet one and hold down SHIFT and click on the tab for the last sheet. All the tabs should be selected and the same colour.

Now any changes made in Page Set Up will affect all the sheets, same for fonts, font size, colour etc...

  Mr Anderson 18:01 16 Jul 2003

You legend, thank you very much!!!!!!!!!

I guess I probably could have looked up the help but I was here anyway.

Cheers

  Jester2K II 19:46 16 Jul 2003

Bah!! Only because VoG was too slow to get here first.....

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

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone