![]() |
margins and page size in worksheet
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 |
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 |
All times are GMT +1. The time now is 10:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com