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.
You should read it
- How to repeat titles in Excel 2007, 2010 and 2013 when printing
- How to print Excel on an A4 page
- How to fix the error of printing missing documents in an Excel sheet
- How to print an Excel spreadsheet in a page
- How to delete white pages in Excel
- How to remove words Page in Excel, delete sinking text Page 1, Page 2 in Excel
- How to align printed pages in Excel
- How to number pages in all versions Excel (update 2020)
- How to Insert a Page Break in an Excel Worksheet
- How to format paper sheets before printing in excel
- How to change worksheet size in Excel
- MS Excel 2007 - Lesson 13: Format sheets and prints
May be interested
How to print multiple PDF files at the same time is very simple and fast
How to print test pages, test printers in Windows 10
How to fix printer errors that are blurry, not bold, not clear?
Steps to fix printer error that can only print 1 page
8 best AirPrint printers in 2021
Steps to fill ink into HP printer