What a disappointment it is, that when you print a job in Excel, you realize that the printed sheet is coming out with errors. You waste time, and resources. But don’t worry. Here we will explain how to hide or remove errors when printing an Excel sheet in a simple way.
The most common are usually when printing a table and reflecting wrong messages by formulas. If your case is, that it crashes when you print, you can contact Microsoft support for Excel.
When printing Data Tables
If in preview before printing, you notice that the table in Excel appears cut, it only reflects a portion of data, we recommend that you first make a couple of adjustments that are necessary and basic. We will indicate it below:
- We go to the top menu and activate the “Page Design” tab.
- You click on “Margins”. At this point we will verify if we are taking advantage of all the space we have on the sheet. To do this, we can enable the ” Narrow Margin ” option.
- Another resource that can help us is, marking the sheet as “Horizontal”. You can find it with the label “Configuration”, within the “Page Design ” tab.
- Then in the attached label called “Size”, check if you have activated the size of the sheet.
At this point, we check if the table is square within the printing margins. We go to the menu, click “File” and then “print.” If our work on the excel sheet looks perfect. We have achieved it. If instead, we see that the table covered a little more, but still cut, then we will do the following:
- We select with the mouse the space we want to print, or in this case, the data table.
- Activate the “Page Layout” tab, and click on “Printing area” and click on “Set printing area”.
When making these modifications, we go back to the “print” preview. And we can visualize the work area or the table with its complete data, without cuts. But what if we still notice the skewed table, because those things happen. Now we explain the last move you can make, so you can print without errors.
If the error to print persists
- Go to the top menu, activate the “View” tab .
- And we go to the “Page break” icon .
- It will show you that the page contains only one part. At this point, all you have to do is, with the mouse we move the boundary line of the page , and drag it so that it covers the entire table.
With these modifications you can go to preview “print”. You will notice that now the table is fully displayed. Without errors we provide you with more information about printing tables in Excel. Previously we commented that another drawback is the error message that is presented in the cells with the formulas. Pay attention, we explain step by step:
Hide errors when printing
- We are located in the section to print, It is in the “File” menu.
- In the configuration part, we go down and click on “Configure page” .
- The “Page Setup” dialog window will open .
- In the “Sheet” tab, we will focus on the section “Cell errors such as:”
- We select the option “<empty space>”. This will allow errors found in the cell to be displayed as empty spaces. Hide mistakes. So even if your Excel worksheet has errors, it won’t show up on print. Even so, we have several alternatives for you to avoid errors in the cells.
In this article, you will notice how easy it is to hide or eliminate errors when printing in Excel . This knowledge is very useful and we hope you can take advantage of it. You can even expand your knowledge to adjust your jobs before printing. Tell us about your experience and leave us your comments.