Excel.Tips.Net ExcelTips (Menu Interface)

Using Duplex Printing

Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Using Duplex Printing.

Some printers support duplexing, meaning that they allow printing on both sides of a piece of paper. For instance, an HP LaserJet 2420 prints duplex but other models of HP printer may not offer this as an option. Assuming that you have a printer that supports duplexing, and that you have a printer driver that supports it, you can turn it on by following these steps:

  1. Choose the Print option from the File menu. This displays the Print dialog box.
  2. From the list of available printers, select the printer on which you want the document printed.
  3. Click on the Properties button. This displays a Properties dialog box for the printer you selected. (See Figure 1.)
  4. Figure 1. An example Properties dialog box for a printer.

  5. Look through the tabs in the dialog box to locate the controls for duplexing. They may be named something like Flip on Long Edge, Flip on Short Edge, or Print on Both Sides. (The exact wording depends on the type of printer driver you have installed.)
  6. Close the dialog boxes and print your document.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2894) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Using Duplex Printing.

Related Tips:

Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!


Leave your own comment:

  Notify me about new comments ONLY FOR THIS TIP
Notify me about new comments ANYWHERE ON THIS SITE
Hide my email address
*What is 4+5 (To prevent automated submissions and spam.)
          Commenting Terms

Comments for this tip:

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form below!)

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us


Advertise with Us

Our Privacy Policy

Our Sites


Beauty and Style




DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)



Home Improvement

Money and Finances


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 © 2015 Sharon Parq Associates, Inc.