Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 365. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Printing a Draft of a Worksheet.
Written by Allen Wyatt (last updated September 5, 2022)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 365
Excel allows you to print drafts of your worksheets. This can be very helpful in speeding up the printing process. When printing drafts, Excel doesn't include graphics or graphic-related items (such as gridlines) in the printed output. Instead, all you see is the text or numbers that make up your worksheet. To print a draft, follow these:
Figure 1. The Sheet tab of the Page Setup dialog box.
Remember that the exact way in which draft printing is implemented is, in large part, up to your printer. Don't be surprised if you get different results doing a draft print on one printer as compared to another.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6148) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 365. You can find a version of this tip for the older menu interface of Excel here: Printing a Draft of a Worksheet.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
If you want to automatically print a particular area of your worksheet at a specific time of day, you'll love this tip. ...
Discover MoreEver printed out a worksheet only to find that you have text only at the left side of each page? You can use more of each ...
Discover MoreExcel allows you to repeat rows at the top of every page of a printout. If you want to repeat rows at the bottom of every ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2024 Sharon Parq Associates, Inc.
Comments