Using Duplex Printing
Some (but not all) printers support duplexing, meaning that they allow printing on both sides of a piece of paper. 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:
- Press Ctrl+P to display the Print dialog box (Excel 2007) or printing options (Excel 2010 and Excel 2013).
- From the list of available printers, select the printer on which you want the document printed.
- Click on the Properties button (Excel 2007) or Printer Properties link (Excel 2010 and Excel 2013). Excel displays a Properties dialog box for the printer you selected.
- 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.)
- Close the Properties dialog box.
- Use the controls in the Print dialog box (Excel 2007) or printing options (Excel 2010 and Excel 2013) to print your worksheet as you normally would.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (8187) applies to Microsoft Excel 2007, 2010, and 2013.
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:
Comments for this tip:
Thana 08 Mar 2016, 23:30
how to print front and back in excel
Sharlie Huffman 12 Jul 2015, 20:14
I am using Office 13 and this tip does not work. I put the printer properties to duplex and the print command to print the workbook double sided and nada - each sheet comes out separately. It will not double side across sheets.
KT 03 Jun 2015, 12:50
I am now using Excel 2013 and this Tip does not work. Under "Finishing", the only option is to "Print on Both Sides (Manually). This means I have to go to the printer and flip the pages over. My older versions of Excel printed on both sides just fine.
Amy 30 Jan 2014, 09:04
Our office uses Excel 2007, and this tip does not work. I don't have any trouble printing double-sided, but I can't find an option to "flip on short side."