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 Do you want to print a worksheet without the unsightly errors that may be normally visible? Using the steps in this tip, you can instruct Excel to treat those errors specially when it comes to printing. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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 Excel includes the ability to reduce a printout so that it fits on a desired number of pages. This tip explains the scaling feature, and provides a way you can make sure that your printout is never more than a single page wide. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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

ExcelTips
Excel 2007 Tips
WordTips
Word 2007 Tips
Vital News Home
 
ExcelTips FAQ
ExcelTips Premium
 
Learn Access Now
 
Beauty Tips
Car Care Tips
Cleaning Tips
College Tips
Cooking Tips
Gardening Tips
Health Tips
Home Improvement
Money Tips
Pet Tips
Tips.Net Home
 
Advertise on the
ExcelTips Site

 

RSS Feeds

 Daily Nuggets (an ExcelTip every day)

 Allen Wyatt's ExcelTips (the weekly classic)