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!

Jessica Tanner

Update 14 August 2020