Shulou(Shulou.com)11/24 Report--

The title of the original text: "how to print a long form on one page?" It's actually very simple! "

Hello, everyone, I am a farmer, a farmer who specializes in difficult and complicated numbers.

In the daily office, we often need to print out the data sorted out in Excel.

However, it seems like a simple print, in the actual operation, we always encounter a variety of problems ~

For example:

How do I print the same category data from a worksheet on one table?

How do I print a worksheet that spans two sides on one page?

How to print pages according to your own needs?

How do you print out every page with the same title?

.

Today, I will lead you to take an inventory of the common printing functions in Excel to help friends solve the printing problems encountered in their daily work.

1. Use frequency of printing data on one page: ★

Operation difficulty: ★

There are actually two ways to deal with it.

The first kind of ▋, mouse movement, selection range

Select Paging Preview in the View tab

At this time, when you place the mouse over the dotted line and turn it into a two-way arrow, drag directly to the appropriate position.

The second kind of ▋, page setup, adjust page width and height.

❶ clicks on the small triangle at the bottom right of Page setup in the Page layout tab.

❷, click "Page" in the pop-up "Page setup" window, select "adjust to" in the "Zoom" column, and fill in 1 width and height.

2. Add print area usage frequency: ★

Operation difficulty: ★★

In our work, we often encounter this situation:

The print area has been set up, but another part of the data in the data table needs to be added temporarily to print.

Does it need to be reset? Not really.

There is a function in Excel to increase the print area without deleting the set print area.

Procedure:

❶ select the area to be printed, and click "print area"-"set print area" in the "Page layout" tab.

❷ click "Page Preview" in the "View" tab, select the area that needs to be added to the print area, and right-click to select "add to print area".

Take a wave of moving pictures.

By the way, if there is too little data in the table, such as this:

You can go to the Page setup, click the margin, and check horizontal and Vertical in the center mode.

In this way, the printed data is in the center of the page, and the typesetting is more beautiful.

3. Frequency of data paging printing: ★

Operation difficulty: ★★★

In our work, we often encounter this situation: several forms are put on the same worksheet, and we need to print each form onto a separate piece of paper.

For example: the following four forms, we need to print to four pages of paper, how to deal with this?

At this time, we use the function of "paging printing".

"pagination printing" is very simple, in order to make it easier for you to see it more intuitively, we first change the page to [paging preview] mode.

❶ first click "Page Preview" in the "View" tab to enter the page preview mode ~

❷ selects the appropriate column or row, clicks the "separator" in the "Page layout" tab, and selects "insert Page break", which divides the worksheet into the appropriate number of pages just like cutting watermelon.

❸ press the shortcut key [Ctrl+P], click [print], and you can print them on separate paper.

4. Classification and paging printing frequency: ★

Operation difficulty: ★

In the previous case, we have to print the data of the same city on one page.

Let's take a look at the steps:

❶ Click "Classification Summary" in the "data" tab ~

❷, on the classified summary page, fill in:

[category field]: city name

[summary method]: summation

[selected summary item]: city name

You can use the default option. But be sure to check [each set of data pagination], which automatically inserts page breaks between different cities, eliminating the hassle of manual insertion.

❸ selects any column except column An and column B, use the [F5] shortcut to bring up the positioning conditions page, select [Null]-[OK], then right-click, and select delete [entire row].

❹ will delete the summary column, and then "paging print" will be fine.

Knock on the blackboard:

If you want to have a title row on each page, you need to click print title on the Page layout tab.

Then set the [top title line] in [Page setup] to the title line that needs to be printed, and finally click "OK".

5. Print header and footer frequency: ★★★

Operation difficulty: ★★★

In practice, what if you want to add the company name or Logo and the number of pages to each printed page?

At this time, you need to use the header and footer function in Excel.

▋ fixed format

❶ can enter the page setup page by clicking the button in the lower right corner of the "Page layout" tab.

❷ select [header / footer], and you can select the set format directly in the drop-down arrow of [header or footer].

▋ Custom format

Excel not only provides fixed format headers and footers, but also allows users to customize the format ~

❶ returns to the "Page setup" window above, and click "Custom header / footer" to set information.

❷ takes custom footer settings as an example. According to your needs, you can insert page numbers, dates, file information, tables and pictures in the left, middle and right of the footer.

At the same time, comparing some functions in Word, you can also set up page settings [parity different], [home page different], etc.

6. Print all worksheets with frequency: ★★★

Operation difficulty: ★

In practice, we often need to print out all the worksheets in a workbook.

Do you want to click on each worksheet and print it? Of course not.

Use the shortcut key [Ctrl+P] to enter the printed page in Excel, and change [print active worksheet] to [print entire workbook] in the settings, thus OK ~

Is it easy to stir-fry chicken? Don't print one by one in the future.

7. Do not print error value usage frequency: ★★

Operation difficulty: ★

Now, we have been able to cope with most of the printing needs in our daily work.

However, we may also encounter in the work: there are wrong values caused by formula calculation in the printed form, but these error values are not suitable for printing on paper, do we have to delete them first and then print them?

Of course not, Excel can easily deal with it, do not print error values ~

❶ enter [Page setup], and click [worksheet] in the pop-up window.

❷ finds [error cells are displayed as] in the print bar, and selects the way you want to display error cells. For example, if I choose [] here, the error value cells printed out will be blank.

Did you learn it?

8. Print annotation frequency: ★★

Operation difficulty: ★

In addition to the error values in the worksheet, some datasheets also have annotations, so is there a way to print out all the annotations in the datasheet?

Of course there is!

We also find the instructions and comments in the print bar on the worksheet page in the page setup, and select where you want the comments to appear, for example, we select the end of the worksheet.

Then in the printed data, there will be one more page to display the cell where the annotation is located, the person who added the annotation, the content of the annotation and the date.

9. Other usage frequency: ★

Operation difficulty: ★

Printing a data table with Excel is also used occasionally. For example, at work, the shading and color in the data table cannot be displayed. In this case, we need to check "monochrome print" in the print bar in "Page setup".

If you want to display gridlines in the printed data table, you need to check "gridlines" in the "print" column in the "Page setup".

These are the printing functions that we often use in our daily work. Do you know how to print them?

In Excel, we deal with print-related settings, mainly in the Page layout tab and Page setup.

So, if you have any problems with printing in the future, you can go to these two places to have a look.

The tips in Excel are much more than what I introduced today.

For example, a powerful Excel master can process data more efficiently with only one shortcut key, making your work get twice the result with half the effort.

When you get an urgent task at work, what if you don't have time to process the data?

If you Get the Excel way of thinking, even if you use only one shortcut [Ctrl+E], you can quickly get the data 👇.

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: farmer

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.