Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 11th 09, 01:22 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 105
Default Same Margins with Multiple Worksheets (2003)

I have a document with nine worksheets. I want the margins to be the same.
Is there a way to set this up without having to do so nine times?



  #2   Report Post  
Old September 11th 09, 01:51 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Same Margins with Multiple Worksheets (2003)

For some settings, you can group the sheets you want the same and then do
File|page setup.

But not all settings can be modified this way.

And remember to ungroup the sheets when you're done!

You can group the sheets by selecting the first and ctrl-clicking on the tabs of
the subsequent sheets (or rightclick on any tab and choose "Select all sheets"
if that's what you need)

Helen wrote:

I have a document with nine worksheets. I want the margins to be the same.
Is there a way to set this up without having to do so nine times?


--

Dave Peterson


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Synchronizing multiple worksheets in a workbook (Excel 2003) jms Excel Discussion (Misc queries) 1 February 12th 08 09:41 PM
Excel 2003 Referencing multiple worksheets EdGarrett Excel Discussion (Misc queries) 3 January 31st 08 03:48 PM
Set margins on multiple worksheets at once astrange Excel Discussion (Misc queries) 3 August 1st 06 06:20 AM
Sort rows across multiple worksheets - Excel 2003 Stamdale Excel Worksheet Functions 2 July 5th 05 04:30 PM
how to change margins for multiple worksheets in Excel? eksus Excel Worksheet Functions 0 June 28th 05 05:16 AM


All times are GMT +1. The time now is 11:19 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017