How the Excel print form covers the whole piece of A4 paper

In the workplace office, we often print forms there will be a lot of blank around the paper, can not cover the entire page.

As shown in the following figure, there are too many blanks around the form, which is too wasteful. How can you spread the form all over the A4 paper page? Not yet, friends, let's study together!

Let's center the form first. Enter "document"-"print", click "Page setup"-"margin" at the bottom, check "horizontal" and "Vertical" in "Center Mode", and finally determine. Now, our table is moved to the center of the page.

Print preview effect.

Set to zoom into "File"-"print", click "Page setup" at the bottom, and enter a value in "Zoom"-"Zoom" in "Page". Because our table is too small to cover the entire page, we need to enlarge the table, where the scale value needs to be entered according to our own table, you can try a few more values to achieve the best results.

Print preview effect.

Reduce the margin, of course, if you want to enlarge the table a little bit and make the margin as small as possible, you can narrow the margin.

Enter "File"-"print", click "Page setup" at the bottom, and set the "margins" and headers and footers to "0".

Next, we go to the "page" and set the "zoom" a little larger.

Print preview effect.

Not only is there no large amount of white space around it, but also the table text is obviously enlarged, which is much better than before!

This article comes from the official account of Wechat: Word Alliance (ID:Wordlm123), author: Wang Wangqi