Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
The following articles are available for the 'Page Setup' topic. Click the article's title (shown in bold) to see the associated article.
Changing Page Margins
If your worksheet is destined to be printed, you'll need to be concerned with how it appears on the page. One layout setting you can easily control is the margins surrounding your worksheet.
Changing Paper Size for a Complete Workbook
If you need to change the size of paper on which your worksheets will be printed, it can be bothersome to make the change on each worksheet individually. Here's how to make the change on the entire workbook, at one time, regardless of how many worksheets it contains.
Defining a Custom Paper Size
Need to print your worksheet on a non-standard paper size? Excel is rather limited in printing to such papers, and here is why.
Fitting Your Information
Excel has a few ways to size the width of columns in a worksheet.
Forcing a Page Break
To force Excel to place a page break where needed, follow these easy steps.
Resetting Page Setup
If you ever open a workbook and find that your carefully crafted worksheets no longer print on the number of pages you expect, it could be because of a change in your computer system. This may mean a lot more work crafting the worksheets again.
Scaling Your Printing
If you want to cram more of your worksheet onto each page of a printout, one way to do it is by using scaling. Here's how you can scale the information to get just the right printout size.
Setting Default Print Margins
Don't like the print margins that Excel uses by default? You can change the default by changing the workbook on which Excel bases the new workbooks you create.
Setting Page Margins
When getting ready to print your worksheet, you may want to take a moment to check what margins Excel will use on the printout. The program makes it easy to modify the margins of your printed page.
The following are additional topics related to the subject of Page Setup. A bracketed number after the topic indicates how many articles are related to that subject.