How to fix the error of printing missing documents in an Excel sheet
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 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.
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.
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.
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.
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.
You should read it
- How to fix the error of printing without finishing the page in Excel
- Instructions for alignment in Excel - Adjust the margins for Excel before printing
- How to hide and hide sheets in Excel and show them again
- How to display sheet tabs in Excel
- How to print Excel on an A4 page
- Some tips for printing text in MS Word
- How to create a password protection for Excel sheets
- Instructions for printing two-sided paper in Word, PDF, Excel
- Instructions on how to print text, print documents Word, Excel, PDF details
- How to hide the Sheet Tabs (sheet bar) in Excel
- Basic tips with Sheet in MS Excel
- Some printing tips are essential in excel
Maybe you are interested
5 Ways to Fix 'Can't Reach This Page' Error on Microsoft Edge
Excel 2016 - Lesson 12: Formatting pages and printing spreadsheets in Excel
How to take a screenshot of the entire web page on Microsoft Edge
How to translate a web page on Microsoft Edge
How to use Apple Intelligence to summarize emails, web pages, and text
How to print Excel on 1 A4 page - Display full content on 1 page