bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > ExcelTips Home > Printing > Setting Up Your Printer

Setting Up Your Printer

Summary: Printers have many capabilities that you can take advantage of in Excel, if you just know how. This tip explains how to access all the features of a printer through the printer’s driver interface. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

You can change the settings Excel uses when printing through your printer in the following manner:

  1. Choose Print from the File menu. Excel displays the Print dialog box. (Click here to see a related figure.)
  2. Using the Name drop-down list, select the printer you want to use. (It is common to have more than one printer available if you are working in a networked environment.)
  3. Click on the Properties button. Excel displays the Properties dialog box for the printer you selected in step 2. (Click here to see a related figure.) The exact appearance of the dialog box, and the controls it contains, depends on the printer driver you have installed for your printer.
  4. Using the tabs and other controls in the dialog box, specify the printer settings you want to use.
  5. Click on OK to close the Properties dialog box.
  6. Click on OK from the Print dialog box. Your worksheet is printed.

Tip #3235 applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003


Tame Your Data! ExcelTips: Filters and Filtering provides all the details necessary to let you manage large sets of data with confidence and ease. Its information-packed pages demonstrate how to use the two types of filters provided by Excel: AutoFilters and advanced filters.
 
Check out ExcelTips: Filters and Filtering today!

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home
Vital News 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

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)