More Topics

The following are additional topics related to the category listed above. A bracketed number after the topic indicates how many articles are related to that subject.

• Headers and Footers [34]
• Page Numbers [6]
• Page Orientation [2]

Tips, Tricks, and Answers

The following articles are available. 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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Changing Paper Size for a Complete Workbook Do you need to change the type of paper used to print each worksheet in a workbook. There are two ways you can make a universal change, and the one you select depends on the complexity of your worksheet formatting. This tip describes both methods of making the change. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Fitting Your Information Excel has a few ways to size the width of columns in a worksheet. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Forcing a Page Break To force Excel to place a page break where needed, follow these easy steps. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Setting Default Print Margins You may not like the default margins set by Excel for worksheets. The way to change those margins is to create a template for new workbooks that has the margins set the way you require. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

RSS Feeds

 Daily Nuggets (an ExcelTip every day)

 Allen Wyatt's ExcelTips (the weekly classic)