Excel question

  Mr Anderson 17:47 16 Jul 2003

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.


  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

Dell XPS 13 9370 (2018) review

The art of 'British' pulp fiction

Best password managers for Mac

TV & streaming : comment regarder le Tournoi des Six Nations 2018 ?