Printing
Printing in Excel is very easy. At the simplest level, just press the print button and call it done. However, here are a few tips to make your print-outs look more professional and readable.

  1. Always use File | Print Preview to see whether it makes more sense to print your sheet portrait or landscape. If you have a wide spreadsheet, use landscape. If it is a tall spreadsheet, use portrait.

  2. Use the "fit-to" scaling feature (under File | Page Setup), to force your spreadsheets to print on one-page. I use this feature for almost every spreadsheet I print and my settings are almost always as shown below. Remember that anything you do in the Page Setup dialog only pertains to the worksheet tab you currently have selected.



  3. Headers and footers are a good way to consistently and professionally mark your spreadsheets. Access the controls for headers and footers by going File | Page Setup and selecting the Header/Footer tab. I usually click the Custom Header or Custom Footer button and enter my info in the resulting dialog. Here is an example of a typical header:



You have reached the end of our Excel tutorial. Thank you for visiting our site and please tell a friend if you liked what you saw. Please check-back frequently for updates or subscribe to our newsletter. Our newsletter is published at most four times a year & your email alias will always be kept confidential.

[Return to Introduction]
[Return to Home Page]




Previous Chapter ||| Subscribe ||| Introduction ||| Next Chapter


TGW.NET is property of Tim Whelan. All pictures and text ©Tim Whelan 1980–2001, all rights reserved. Only permitted images and material may be downloaded from this web site. For useage, please see my copyright notice.