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

Printing is a very common thing in our work.

For many small partners, printing is a matter of "putting paper, dot printer, no technical content".

But Excel printing is not that simple...

The 9 magic weapons taught today will solve most of your problems in Excel spreadsheet printing!

The first big magic weapon: repeat the title line When we print, the first page is usually set with the title and header:

But when I printed page 2, I found that the title and header were missing:

What would you do at this time?

In those days, I inserted the line stupidly, copied and pasted the title many times, really unbearable to look back on the history of blood and tears ah.

In fact, the setting of printing titles and headers for all pages is very simple. The steps are as follows.

Step 1. Click Page Layout-Print Title to open the Page Settings dialog box:

Step 2. Find the Worksheet tab in the opened Page Settings window, manually enter $1:$3 in the text box on the right of the Top Title Line, or click the Collapse button on the right

。

Select rows 1 to 3 in the worksheet and click OK to complete the operation:

That's it!

The second magic weapon: setting the print area Sometimes, we will use auxiliary columns when making tables, but we don't want these auxiliary columns to be printed when printing.

For example, the following worksheet:

I only want to print the left part, the right part (utilities, property fees, others) is only used as auxiliary data, do not need to print.

Try it: Use the print area function.

Step 1. Select the area to be printed, such as columns [A:H] in this example, as shown in the following figure:

The advantage of choosing whole columns is that when new data is added, there is no need to reset the print area.

Of course, you can also select a fixed area, such as the area in this example can be set to [A1:H54].

Step 2. Click [Page Layout]-[Print Area]-[Set Print Area] to complete the operation:

The animation demonstrates as follows:

Note: Print _ Area displayed in the name box is the print area.

The third magic weapon: good use of paging preview Have you ever encountered a page printed more than one page, and the second page printed very little content?

Do you adjust the margins manually?

This is one way, here is a faster way:

Step 1. Click View-Pagination Preview to display the page view in Pagination Preview mode:

Step 2. When the mouse moves to the blue dotted line, the mouse becomes a two-way arrow [

], the line can be dragged to adjust the print page.

In this example, you can drag the blue dotted line to the thick blue line at the bottom to adjust the original 2 pages to 1 page:

The animation demonstrates as follows:

The fourth magic weapon: quick adjustment of the number of pages printed or the example above, is there another way to quickly adjust the number of pages?

The answer is yes, the steps are as follows:

Step 1. Click the [Page Layout] tab-click the arrow in the lower right corner:

Step 2. In the opened [Page Settings] window, operate as shown below:

Note: In the case of roughly determining the number of pages printed, it is a quick way to directly set the page height here, that is, how many pages directly set the page height.

For example, if it is two pages, set the page height to 2.

The operation animation is shown as follows:

The fifth magic weapon: set monochrome printing If part of the worksheet line identifies the background color, the background color is gray after the black and white printer is printed, which greatly affects the display effect.

I don't want to show these background colors when printing. Should I delete the bottom layer first when printing and set it back after printing?

There was no need to go through so much trouble!

Monochrome printing can be set up as follows:

Step 1. As shown below:

Step 2. In the opened [Page Settings] window, operate as shown in the following figure:

The animation demonstrates as follows:

The sixth magic weapon: multiple worksheets consecutive page numbers when you have multiple worksheets in your workbook, when printing the page numbers need to be consecutive, then what do you do?

Do I set the starting page number for each worksheet?

In fact, there is no need to set the starting page number at all, just select the worksheet to print when printing, and the page number will automatically be continuous when printing output.

Before multi-sheet printing is selected, the page numbers in the footer of a single sheet setting are as follows:

Note: For display convenience, I set the worksheet name in the lower left corner.

When multiple worksheets are selected, the footer page numbers for print preview look like this:

Do you see the difference?

There is no need for special settings at all. When you only need to print, select the worksheet you want to print first and form a working group. Do you understand?

The animation demonstrates as follows:

Seventh magic weapon: multi-worksheet merge printing [worksheet 5] and [worksheet 6] shown in the following figure to print on 1 page, how would you do it?

Because the column widths of the two tables are not the same, the idea of printing directly into a worksheet does not work.

What should I do more conveniently? Follow me below to operate ~

Step 1. Select the data area of one of the tables, such as worksheet 6, shortcut key Ctrl + C or right-click menu to copy the selected data area:

Step 2. Select another worksheet to be printed on the same page, right-click, and select [Link Picture] in [Paste Selective]:

Step 3. At this point in worksheet 5 will appear with a link to the image, the image content of the data area just copied.

And the image content will automatically change with the data in worksheet 6, and the image can also be resized according to your own requirements:

Step 4. At this point the data in the same worksheet, click print directly to print to the same page of paper.

The eighth magic weapon: let the header automatically number. The leader gave me a difficult problem and asked me to indicate the number of pages on the header.

For example, 1/4, 2/4, 3/4, 4/4, etc., as shown in the following figure:

The header cannot be changed automatically if it is placed in the worksheet. If it is placed in the header, can it not be changed automatically by using the page number?

Come and practice it quickly. The operation steps are as follows:

Step 1. Copy header contents, hide header rows after copying, paste contents into header:

Step 2. Click Page Layout, and in the open window, click Custom Header:

Step 3. Paste the copied header content into the edit bar in the middle of the header:

Step 4. Replace 1 in the number with [Insert Page Number], and replace 4 in the number with [Insert Page Number]:

Step 5. Set text font and font size, click OK:

In this way, when printing preview, you can see that the number of the header will automatically change.

Have you ever had to page by department, company, product, or specific content?

If so, how do you operate it?

Insert page breaks manually? Or split into multiple worksheets and print them?

You can also take advantage of the pagination feature of the subtotals!

👉1 minute to complete the "Summary by Department" and complete the "Pagination Print"!

The animation demonstrates as follows:

After mastering the nine magic treasures, any problems you encountered when printing would be solved!

This article comes from Weixin Official Accounts: Autumn Leaf Excel (ID: excel100), Author: Wayy, Editor: Zhu Lan

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.