Loading
Excel.Tips.Net ExcelTips (Menu Interface)

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
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.

 

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.

 

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us

 

Advertise with Us

Our Privacy Policy

Our Sites

Tips.Net

Beauty and Style

Cars

Cleaning

Cooking

DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)

Gardening

Health

Home Improvement

Money and Finances

Organizing

Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives

 

Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2016 Sharon Parq Associates, Inc.