Page setup in excel

[Bala]

Gurus,

I have many worksheets in a spreadheet. How do I "page setup" for all the worksheets together ?.
I don't want to do "page setup" one by one.

Pls. advise me.


-Bala

 

[Brian from Maui]

Gurus,

I have many worksheets in a spreadheet. How do I "page setup" for all the worksheets together ?.
I don't want to do "page setup" one by one.

Pls. advise me.


-Bala

Click on the first worksheet tab, hold down the Shift key, click on the last worksheets tab, then go to Page Setup

 

[golf4]

Hi, Bala -

You may want to check out www.asap-utilities.com for the Excel utility. I did have it on my machine, and it helped you do a lot of things. Maybe the one you're looking for is one of them. It's worth checking out.

HTH,

Golf

 

[Bala]

Brian,

It works. Thanks. ...Simple logic but can't think of it......OK....that is why you are GURU !!!

Golf4,

I will try it. thanks.

-Bala

 

[apurk45]

Hi

Try this:
Hold down the SHIFT button
Select each WS Tab you want set-up (on the bottom of your page)

File
Page Setup

Now all the setting you make will apply to all you WS's

This will work for most of the setting except protecting / unprotecting

I hope this will help

Apurk45