How to fix the error of printing missing documents in an Excel sheet

The situation of printing missing Excel page content is not uncommon, especially with Excel documents with many columns and many rows, sometimes missing pages will be printed. This is not a document printing error that is too difficult to fix, requiring the intervention of a repairman.

You just need to check the print mode and set up the Excel print page. The following article will guide you to fix the error of printing the entire Excel page.

How to check that Excel print fits A4 page

First at Excel data, users click on View and then look down at the Workbook Views group, we choose to continue to Page Break Preview or Page Layout .

As a result, you will see whether the Excel content printed an A4 page or not through Page 1, Page 2, .

How to fix the error of printing missing documents in an Excel sheet Picture 1How to fix the error of printing missing documents in an Excel sheet Picture 1

How to adjust print settings in Excel

Step 1:

You click on the Page Layout item on the toolbar and then select the Margins item to align the margins.

Here you will see the Normal, Wide, Narrow options to adjust immediately or Custom Margins to adjust the parameters as you like.

How to fix the error of printing missing documents in an Excel sheet Picture 2How to fix the error of printing missing documents in an Excel sheet Picture 2

Step 2:

At this point, you will adjust the parameters of the margin to adjust the print. After editing, click OK to save this setting.

How to fix the error of printing missing documents in an Excel sheet Picture 3How to fix the error of printing missing documents in an Excel sheet Picture 3

Step 3:

Next, the user clicks on Page Layout and then selects Portrait to print vertically or Landscape to print horizontally. For spreadsheets with too many columns, you should choose a horizontal page style to make the table wider.

How to fix the error of printing missing documents in an Excel sheet Picture 4How to fix the error of printing missing documents in an Excel sheet Picture 4

Instructions to print Excel to fit 1 page

If the data table is relatively long if printed vertically or too wide if printed horizontally, you can resize columns and rows.

We click View and then choose to adjust the column width, the row height to adjust the column width, the row height of the Page Break Preview item. The user then proceeds to adjust the column width and row height so that the content fits in a printed page.

To return to the old page view, click View and click Normal.

How to fix the error of printing missing documents in an Excel sheet Picture 5How to fix the error of printing missing documents in an Excel sheet Picture 5

Adjust print mode in Excel

After you have adjusted all the parameters for the printed page, you will proceed to adjust the printing mode in Excel.

We click on the File item and then select Print, then click on the Print item to edit. At the print document editing interface, we will choose the 1-sided printing or 2-sided Excel page printing. Finally select the number of prints you want. If you choose to print on both sides, you should choose Print Both Sided – Flip pages on short edge.

How to fix the error of printing missing documents in an Excel sheet Picture 6How to fix the error of printing missing documents in an Excel sheet Picture 6

4.5 ★ | 2 Vote