Written by Allen Wyatt (last updated November 30, 2024)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, 2021, and Excel in Microsoft 365
Excel obviously allows you to print your worksheets to a printer. Sometimes a worksheet will fit on a single page, but other times it will flow to multiple pages. You may be wondering how you can print different pages on your printer, as you can print different pages of a Word document.
If your worksheets each will fit on their own page (a single sheet), then the answer to the question is easy: all you need to do is select the worksheets you want to print before you actually print. For instance, if you want to print worksheets 4, 8, and 10, all you need to do is click on the first worksheet's tab (worksheet 4 in this scenario), then hold down the Ctrl key as you click on the second and third worksheet tabs (worksheets 8 and 10). When you print, only those three worksheets will be printed.
If you want to print specific pages out of a single worksheet that normally prints on multiple pages, then the answer is a bit more difficult. One solution is to temporarily hide the unwanted portions of the worksheet and then print the unhidden areas. An easier solution is as follows, however:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (10263) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, 2021, and Excel in Microsoft 365. You can find a version of this tip for the older menu interface of Excel here: Printing a Number of Different Pages.
Dive Deep into Macros! Make Excel do things you thought were impossible, discover techniques you won't find anywhere else, and create powerful automated reports. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable. You’ll find step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and solutions. Check out Microsoft Excel 2019 VBA and Macros today!
If you want to cram more of your worksheet onto each page of a printout, one way to do it is by using scaling. Here's how ...
Discover MoreIf you are using a macro to create your printed Excel output, you may need a way to specify that paper should come from a ...
Discover MoreIf your worksheet, when printed, requires more than a single page to print, you may want to only print a range of the ...
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 © 2025 Sharon Parq Associates, Inc.
Comments