Written by Allen Wyatt (last updated September 3, 2022)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, 2021, and Excel in Microsoft 365
Ever had this happen to you? You run a print job and are surprised to get 22 pages of output. That would have been fine, except you were expecting one or two at the most. Problem is, most of the pages that came out of the printer are empty!
The problem is most likely that you mistakenly selected a cell at a distant column and row and bumped into your Space Bar. That leaves no visible signs, but Excel thinks you want to print this space.
The solution is as simple as this:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (11945) 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: Massive Printouts.
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 Data Analysis and Business Modeling today!
When you print a worksheet, Excel allows you to also print handy gridlines for the worksheet. If you want to include the ...
Discover MoreNeed your printed output to look its best? You may need to change the settings used by your printer, then. Here's how to ...
Discover MoreWant to print out the fastest possible copy of your worksheet? You do so by printing a draft, discussed in this tip.
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2022-09-03 15:27:02
J. Woolley
Also, see https://excelribbon.tips.net/T012970_Jumping_to_the_Last_Possible_Cell.html
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