It happens to many that when they finish their work in Excel and go to print, the sheets are cut off or incomplete , and two sheets are printed instead of one, which causes it to be necessary to hide a row or column in Excel to try to print the document correctly.
In order to avoid this error, you should know that to print Excel files correctly , it is recommended to use the print preview , in addition to configuring and modifying the document margins according to your needs.
How to print my EXCEL files correctly? – Selection guide
Index( )
- What is the way to print in Excel without the table being cut off?
- Go to print view
- set up printing
- Modify print margins
- Make the table fill the sheet
- How to correctly print a Microsoft Excel file?
- All the book
- Active Sheets/Selection
What is the way to print in Excel without the table being cut off?
There are several very useful Tips that you can use in order to print a document in Excel without cutting it , of course it is recommended to eliminate duplicate data in Excel , unnecessary information or empty columns and rows, for greater comfort when configuring the print. In the same way you have the option of:
Go to print view
In Excel you can get a preview of the printing of pages , it is the best thing that you can use to print a table without cutting it , since we directly observe the final result of the printing. In other words, if you notice that the table is incomplete, it is because it would be printed like that.
You should know that to enter the print preview, just press the ‘Ctrl + P’ key combination and you will see the ‘Preview’ option at once, you can also click on the office button and enter directly to print preview , this is valid for any version of Excel you use.
set up printing
The best thing is that in the preview of an Excel document you can enter the page settings, with the purpose of modifying the orientation, scale, sheet type and much more , of course this option is also available in all versions of Excel.
A very useful trick that you can use so that your table does not get cut is that you can adjust the scale a little less than the normal percentage , or use a larger sheet than the one selected for printing.
Modify print margins
When you enter the print settings through the preview, you can activate the ‘Show margins’ box. In this way we observe that some small lines are shown that represent the margins.
You have the option to move any margin you want with the mouse , so that your document is displayed completely and without errors in the preview, a Tip is that if your document has several pages you can navigate through all of them using the mouse wheel.
Make the table fill the sheet
If your table is cut in the preview it is recommended to adjust the table so that it fills the sheet . That is to say that it can be seen without cuts, move the margins, change the orientation and size of the sheet, as many times as necessary, in order to make the table appear perfect.
Remember that you have the option to remove headers or footers , so that the proportion of the page is larger, it works the same way as when adjusting the width of the document, of course all these options must be done from the preview or in the Main panel.
How to correctly print a Microsoft Excel file?
To correctly print a file it is necessary to specify which type of document is selected . That is, if it is a page, a complete book, several pages, among others.
In the print settings you can modify the type of printing you need , also if you can use the split screen in Excel it will be much easier to view. Since you can eliminate the white spaces that are left over without problems. Similarly, it is recommended to choose:
All the book
If you are going to print the entire document that you have created, you must modify the margins so that it looks perfect in the preview . You will notice that when you press ‘Ctrl + P’ or when you enter the print panel using the Office button, at the bottom is the ‘Entire book’ box.
Check the box and enter the preview , you should use this printing method for portrait documents, since the margin is lost if you use the landscape orientation with the ‘whole book’ box checked.
Active Sheets/Selection
When printing, you can activate the ‘Selection’ box, which is perfect if you only want to print a table or a specific portion of the document . You will be able to observe that when selecting a table, the next act you enter the printing panel and check the ‘selection’ box, in the preview only the selected text is shown.
Likewise, if you activate the ‘active sheets’ box, only the one that is in view at that moment is shown , omitting the rest of the document. You also have the option to ‘Skip print areas’ regardless of the box you activate or the type of printing you choose.
It is also recommended that you choose the type of printing according to the document, so that you can correctly print your . Of course, in the case of books, it is advisable to use a printer that adapts to this function, so that you can insert it if necessary.