Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 8,856
Default margins and page size in worksheet

If you group all the sheets together (by right-clicking a sheet tab and
select Group all Sheets), then any changes you make will apply to all
the sheets. So, you could go into Page Setup and adjust your margins to
suit, and this will apply to all sheets.

Just remember to Ungroup the sheets when you have finished.

Hope this helps.

Pete

aamir wrote:
I will try to express myself clearly but I might not be able to fully do so:

I have a 22 page worksheet with each page as a technical data sheet.
When i print these, the text is fine but the size of the main outline border
is different on the different pages---in other words, the space between the
side borders to the side ends of the paper, and the spacing of the top and
bottom border lines to the top and bottom of the paper, is different on
different pages. This may have something to do with margins and page setup, I
am not sure?

In summary is there a way to format these 22 pages so that when they are
printed they are identical as far as the top/bottom borders from the top and
bottom of the page, and side borders from the sides of the page be the same
for all sheets. This does not mean that the spacing of the top/bottom and
sides on a partiular page have also to be the same dimension

I would request your assistance, and also that of Debra Dalgleish if she
sees this question

Thanks a lot
Aamir


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
margins do not fit page size Carol Excel Discussion (Misc queries) 1 September 13th 06 02:33 PM
Margins do not fit page size! law Excel Discussion (Misc queries) 1 September 13th 06 02:20 PM
"Margins do not fit page size" error, but I'm not printing! bubbles1611 Excel Discussion (Misc queries) 0 September 21st 05 03:41 AM
If I change page margins headers don't line up??? CGINUSA Excel Discussion (Misc queries) 2 June 25th 05 12:54 PM
why would page 1 of an excel worksheet print smaller of page 2 if. hisdrama pest Excel Discussion (Misc queries) 1 January 10th 05 07:14 PM


All times are GMT +1. The time now is 08:23 AM.

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

About Us

"It's about Microsoft Excel"