Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
margins do not fit page size | Excel Discussion (Misc queries) | |||
Margins do not fit page size! | Excel Discussion (Misc queries) | |||
"Margins do not fit page size" error, but I'm not printing! | Excel Discussion (Misc queries) | |||
If I change page margins headers don't line up??? | Excel Discussion (Misc queries) | |||
why would page 1 of an excel worksheet print smaller of page 2 if. | Excel Discussion (Misc queries) |