Excel Printing Page Setup...... Excel Printing Page 1
Basic printing in Excel requires no setup, printing is performed using the default settings within Excel. If you want more than a basic print , the Page Setup dialog box is the area used to set up printing to your requirements if you wish to vary them from the default settings. There are two areas that you can access the dialog from, these are from the toolbar available within Print Preview mode, (note that some options are greyed out) or by going to File>Page Setup. If you use this option, all areas will be available to you,
Options you can change via the Page Setup dialog are:
Orientation is the way in which
your paper prints from the printer. Portrait means with the shorter
edge at the top of your page and the longer edges at the sides, and Landscape is the reverse.
There are two options under
this heading. The first option Adjust to __% of normal size will
allow you to reduce or enlarge the print range you have selected. The range
varies from shrinking your selection to 10% of normal size, to expanding
your selection to 400% of normal size.
The second option under this heading is Fit to __ page(s) high by __ page(s) tall. This will make your selection fit on however many pages you specify.
You can change your paper size
here, as well as in your Print dialog box by selecting one of the paper
sizes available through your printer.
You can change your print
quality here, as well as in your Print dialog box.
First Page Number
The default is Auto
which means your printing will Start at page 1. If you wish to print
Starting at another page number, you can type any number other than 1 in
You can change your margins by
typing new ones if you wish, but it is far easier to change your margins by
clicking the Margins button in Print Preview mode and dragging to the
Centre on Page
This option is not available in
Print Preview mode, only by going to the Page Setup dialog via the File
menu. By selecting either horizontally or vertically you will
center your selection on your page either horizontally or vertically.
The definition of a Header or
Footer is something that is required to appear on every page of your
document. As the names suggest, a Header is something that will appear at
the top of every page, and a Footer is something that will appear at the
bottom of the page. In Excel, you can have only one Header and one Footer in
each Worksheet. The Header/Footer Dialog box can be accessed through the
Page Setup dialog box, or via the View menu on your Standard Worksheet menu
The top area of this box is
greyed out. If something is greyed out within Excel, this is because the
options are not available in the area in which you are in. The options at
the top of this box are only available if you access the Page Setup dialog
box via the File menu.
The only options we need to look at here are the ones under Print.
You have two options here; Down then Over and Over then Down. Selecting one of these options will control the way data is numbered and printed when it does not fit on one page.
Remember, if you want more than just a basic print , that there are many features of your page-set up that you can manipulate to your own ends. However, you must also be aware of the people who want to read your printing. There are some tricks to fitting all your printing on one page but sometimes it may be better to spread information over two pages, rather than squash it all on to one page so that it is very small and hard to read.
Click here to go to Excel Printing 3
Excel Dashboard Reports & Excel Dashboard Charts 50% Off Become an ExcelUser Affiliate & Earn Money
Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $64.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
Some of our more popular products are below...
Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To...... | Analyzer Excel | Downloader Excel | MSSQL Migration Toolkit | Monte Carlo Add-in | Excel Costing Templates
FREE Excel Help