How do you use zooming to quickly set up a printed page in Excel?

Source: Internet
Author: User

How do you use zooming to quickly set up a printed page in Excel? Efficient use of page settings, printing not only to improve efficiency, but also to save paper.

1, in the process of printing, often encountered such a situation, the page is set up, after the print preview will find that the last page has very little content, you can print less than one, this must be adjusted to the margins, this is not only the problem of trouble, and you adjust to, adjust to, always feel inappropriate. For example, as shown in the figure, we will find this file, printed on the third page of the content is very small, can be printed on two pages of paper.

2, open the "Page Setup" dialog box, in the "Zoom" function "adjusted to" 1 pages wide, 2 pages high, remember to encounter this situation, the page width is always 1 pages, page height you want to print how many pages, set how many pages wide.

3, but you will encounter a new problem, after setting the two pages, you will find that the printed font will be small.

4, that also need to do page setup. Set the top and bottom margins smaller.

5, set up up and down the margin settings, you will find that he will automatically adjust the proportion to the best effect, do not need to use the Pull method to adjust the margins. Very convenient.

6, in the "horizontal printing" when there will be such a problem, because the column is too wide, or other reasons, we want to print on a page of content, to print to two pages, to drag the margins to be set, this method is not high efficiency

7, the same, open the Page Setup dialog box, under the "Zoom" function "adjusted to" 1 page width, 1 pages high, you can quickly adjust.

8, look at the effect, is not fast, we work in peacetime in accordance with the actual situation, flexible use, and further improve work efficiency.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.