Page Setup

Tips, Tricks, and Answers

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
Using Page Setup to change the margins of your Excel 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.

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.

Hiding Errors on Printouts
If there are error values in a worksheet, you may not want those error values to appear on a printout. Excel actually allows you to specify how those error values are handled.

Resetting Page Setup
Have you had the frustrating experience of your worksheets seeming to have their setup change, without explanation? It could be because of a change in your printer configuration, as described in this tip.

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.

More Information

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.