I created a grid using excel, and would like to print the grid actual size. The one-inch and the half-inch grid squares are not printing correctly. The width is correct but the height is slightly short. Thank you!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How Do I Make Excel Print Actual Size
- Thread starter jdpro
- Start date
shaowu459
Well-known Member
- Joined
- Apr 26, 2018
- Messages
- 734
- Office Version
- 365
- Platform
- Windows
Maybe this is casued by the DPI of your comuputer is different from the DPI of the printer.
There is one solution may solve you problem. Install a PDF printer, print the Excel file to PDF format, then print the PDF file.
There is one solution may solve you problem. Install a PDF printer, print the Excel file to PDF format, then print the PDF file.
Upvote
0
Macropod
Retired Moderator
- Joined
- Aug 27, 2007
- Messages
- 3,764
Excel is not and never has been a true wysiwyg program; printed row heights and shapes have always been short in comparison to their widths, regardless of the printer.
You can work around that by increasing the heights to compensate; typically by around 5%. For a more precise adjustment factor, insert a 4in square onto a worksheet, then print it (even to pdf). The relative differences between the height and width will tell you what adjustment factor to use - which may vary between Excel file formats, versions and printers.
You can work around that by increasing the heights to compensate; typically by around 5%. For a more precise adjustment factor, insert a 4in square onto a worksheet, then print it (even to pdf). The relative differences between the height and width will tell you what adjustment factor to use - which may vary between Excel file formats, versions and printers.
Upvote
0
Solution
