Written by Allen Wyatt (last updated March 30, 2023)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, Excel in Microsoft 365, and 2021
You can change the settings Excel uses when printing through your printer in the following manner:
Figure 1. The Properties dialog box for a printer.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (12200) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, Excel in Microsoft 365, and 2021. You can find a version of this tip for the older menu interface of Excel here: Setting Up Your Printer.
Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!
If you want to print just the contents of a number of rows and columns, it can be challenging to get the output you want. ...
Discover MoreGetting your printouts to appear on a printed page exactly as you want can be a challenge at times. What if you want to ...
Discover MoreBorders not printing properly? It could be any one of a number of reasons causing the problem. This tip provides some ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2017-02-25 17:45:04
Val
@John_MacDonald: I know paper size is printer dependent but most printers I work with, Laser Jet/Print Jet, go as small as 3"x5". There must be something close to the size you need so you don't have to fuss too much with margins ...
2017-02-25 05:39:50
Eyal
this is a tip? I am sorry but any person that knows how to operate a bit of excel is probably aware of the ability to get into printer settings.
I was expecting some information regarding page break, fit page etc...
2012-10-13 09:59:23
The issue I have most often with printers is that I want to print on different size paper (an example golf scoring card) and the printer only allows a few paper sizes. What I end up doing is fiddling with margins row width and height until I get the print centered where I want it on the paper.
In the past some printers allowed custom paper sizes.
Thanks
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 © 2023 Sharon Parq Associates, Inc.
Comments