Creating an excel document that has a lot of data will cause some parts to be truncated.
In general, the paper sizes are A4, A5, Letter, Legal. etc we can map the data to match the paper size that we will use for printing.
First we can use the Set Print Area, we can find the Microsoft Excel feature on the page layout section of the next print area.
Second, we can take advantage of the Print (Microsoft Excel 2010) custom scaling feature
The image above has not applied the print area set, I will just print the excel document immediately, in that view it can be seen that the document is cut off in the landscape position and only 4 columns are perfect and 1 column is cut off, the original has 6 columns.
![]() |
document after setting no code |
Sorry in advance if the preview image is not clear. If you click zoom to page, the preview of the excel document will display the number of columns that are 6 columns.
That’s my review of how to print an excel document into one page so it doesn’t get cut off. Hope it can help friends, Thank you