Show you how to align the printed Excel file with A4 paper
Unlike the data in word files, the data in excel is usually long spreadsheets and sometimes extends beyond an A4 page. However, the print standard for the paper size is only A4. Therefore, before printing, we need to align the data to fit in the A4 size of the printing paper. This will be an extremely detailed guide as well as extremely useful for you offices. Follow along and do not miss it.
1. Turn on the display of the printed page limit line
To be able to see the page limit lines to edit the data to fit the printed page, you must do the following:
Select tab View => at Wordkbook Views => Select Page Break Preview or Page Layout.
Show you how to align the printed Excel file with A4 paper Picture 1
Or you can choose in the lower right corner of Excel.
Show you how to align the printed Excel file with A4 paper Picture 2
If you choose Page Break Preview, Excel's interface will turn into the image below.
The blue lines are the boundary lines of a page. The fuzzy letters count the number of pages Page 1, Page 2, Page 3 . is the print order of pages.
Show you how to align the printed Excel file with A4 paper Picture 3
If you choose Page Layout, the Excel interface will appear as shown below. The Excel worksheet is then divided into pages like Word.
Show you how to align the printed Excel file with A4 paper Picture 4
2. Align the print page to fit A4 paper
Step 1: Select Page Layout => click the box in the lower right corner of Page Setup
Show you how to align the printed Excel file with A4 paper Picture 5
Step 2: The Page Setup window appears, on the Page tab, select Paper size as A4.
Show you how to align the printed Excel file with A4 paper Picture 6
Step 3: Select the width or the portrait of the printed page in Orientation. Portait is vertical, Landscape is horizontal
Show you how to align the printed Excel file with A4 paper Picture 7
Step 4: Set to always print to fit the page at Scaling. In this category there are 2 options:
Adjust to: To scale in%
Fit to: Automatically pressed to fit the number of pages you choose
Show you how to align the printed Excel file with A4 paper Picture 8
Step 5: Align the margin
We move on to the Margins tag. Here, we perform the alignment of the top, bottom, left, and right of the printed page.
Show you how to align the printed Excel file with A4 paper Picture 9
Hope the article will be useful to you in the working process.
Good luck!
You should read it
- Instructions for printing two-sided paper in Word, PDF, Excel
- How to print two sides of paper in Word, Excel, PDF is extremely simple
- Instructions on how to print 2 sides in excel word
- How to print Excel on an A4 page
- How to rotate paper size in Excel
- How to fix the error of printing without finishing the page in Excel
- How to format paper sheets before printing in excel
- How to fix the error of printing missing documents in an Excel sheet
- How to print an Excel spreadsheet in a page
- Some printing tips are essential in excel
- How to repeat titles in Excel 2007, 2010 and 2013 when printing
- Instructions for alignment in Excel - Adjust the margins for Excel before printing