How to fix the error of printing without finishing the page in Excel

Currently, the demand for printing at home has increased, there are also a variety of printer models in the market for people to choose from such as: Canon, Brother, HP, Samsung, Epson. However, not everyone has Proficient in home printing. This article shows you how to fix the error of printing out of pages in Excel simply and effectively.

1. Reset parameters for printed page

Margins - align margins

Step 1: Select Page Layout > Click on Margins (align the margins).

How to fix the error of printing without finishing the page in Excel Picture 1

Step 2: Click Custom Margins, you can adjust the parameters as desired > Select OK.

How to fix the error of printing without finishing the page in Excel Picture 2

Orientation - the orientation of the printed page (horizontal or vertical)

Step 1: Click Page Layout > Open Orientation.

How to fix the error of printing without finishing the page in Excel Picture 3

Step 2: Choose Portrait (vertical) or Landscape (horizontal).

How to fix the error of printing without finishing the page in Excel Picture 4

Size - adjust the page size

Click Page Layout > Select Size > Select the paper size to print.

How to fix the error of printing without finishing the page in Excel Picture 5

Print Area - select the area to print

Step 1: Highlight the text area to be printed.

Step 2: Select Page Layout > Click Print Area > Click Set Print Area.

How to fix the error of printing without finishing the page in Excel Picture 6

Print Titles - set the page title to print

Step 1: Go to Page Layout > Select Print Titles.

How to fix the error of printing without finishing the page in Excel Picture 7

Step 2: Select Row to repeat at top or Columns to repeat at left > Click OK.

How to fix the error of printing without finishing the page in Excel Picture 8

2. Adjust the Excel table to fit the paper size

Step 1: Go to View > Select Page Break Preview.

How to fix the error of printing without finishing the page in Excel Picture 9

Step 2: Align the column widths to fit on a printed page.

Step 3: Go to View > Select Normal.

How to fix the error of printing without finishing the page in Excel Picture 10

3. Adjust print mode for Excel table

Step 1: Open File > select Print or press the keyboard shortcut Ctrl + P.

How to fix the error of printing without finishing the page in Excel Picture 11

Step 2: Adjust the modes in the Print Dialog displayed.

Hopefully, after this article, you already know how to fix the error of printing the entire page in Excel. Do not forget to share useful information with everyone around.

Lesley Montoya

Update 13 September 2021