Excel question

  Mr Anderson 17:47 16 Jul 03

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 03

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 03

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 03

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

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

LG G6 review: Hands-on with LG’s bold, big-screen shot at perfection

1995-2015: How technology has changed the world in 20 years

How the painting-like animated sequences in A Monster Calls were created by Glassworks Barcelona

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…