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

Original title: "Why is the head of the Excel made by colleagues so beautiful?" "

Hello, everyone. I'm Xiaolan who loves and kills each other with Excel.

Colleague Xiaozhu received a form when she was at work today. The leader asked her to check if there were any errors in the contents of the form, such as missing a certain date, a certain value is empty, and so on.

This task is not difficult, but it may be a bit troublesome, especially if the form is too long, it is troublesome to edit and view the form.

The solution is simple. Select the B3 cell and click the [View] tab-[freeze Pane]-[freeze Pane].

If there is only one row of headers, select any cell, and then freeze the first row.

Every Excel table needs a header, according to different work needs, the header often uses different styles, display methods, etc., many people do not know enough about this, may waste a lot of time in the production of the header, and the final effect is not good enough.

Next, I would like to share a few tips on how to make a watch, so that you can say goodbye to the troubles it brings.

Needless to say, let's take a look at ↓↓↓.

Automatic numbering have you ever seen a meter head that can be numbered automatically?

I've seen it! As shown below:

Come and follow me to practice!

👉 operation points: put the header in the header.

❶ double-click the cell where the header is located, copy it, and then hide the header row.

❷, click * * Page layout * *-> * * Page setup * *. In the open window, click * * header / footer * *-* Custom header * *:

❸ pastes the copied header contents into the edit bar in the middle of the header:

❹ replaces 1 in the number with [insert page number], and 3 in the number uses [number of inserted pages] to replace:

❺ is free to set the text font and font size as needed, and click "OK":

In this way, when you print a preview, you can see that the number of the header changes automatically.

I'm sure you've all learned this tip. Next, let's take a look at how the two-column, three-column and slash headers that you often use are made.

The old rules of the two-column watch head, let's first look at the effect picture:

Key points of 👉 operation: set the border.

❶ starts with the "date area" cell in the upper left corner, select the header, press and hold [Ctrl+1] to open [format cells], and click [Border]

Then click the slash icon in the lower right corner-[OK].

❷ type the title in the corresponding position in the header, press [Ctrl+Enter] to wrap the text, and adjust them to the appropriate position with spaces, and then OK!

PS: the text in the cell is set to be left-aligned.

The effect of the heading of the three columns is as follows:

Key points of 👉 operation: divide the region with straight lines and insert the text box.

❶ clicks the shape under the insert tab, finds the Line, draws 2 bars manually, and adjusts them to the appropriate position.

❷ manually insert three text boxes, enter the title, and then change the font color, adjust the position and so on!

PS: there is a disadvantage in this method. When different computers or different software open, the lines and text boxes may be misplaced and need to be adjusted manually.

The diagonal header effect is as follows:

Key points of 👉 operation: adjust the text orientation.

❶ select the area where the header is located, hold down [Ctrl+1] to open [format cells], and click [align].

❷ in the "orientation" bar on the right side of the pop-up window, adjust the text to the appropriate position, click [OK], and then adjust the height of the lower line.

That's it!

In general, the color of our meter head is set to "solid color fill", but in fact, some very beautiful gradients can also be done with Excel.

The ▲ color is set casually, only for the effect to show the 👉 procedure:

❶ select the area where the header is located, hold down [Ctrl+1] to open [format cells], and click [fill].

❷ click "fill effect" to set the gradient color according to the demand in the pop-up window:

Have you ever encountered a situation where there are so many columns in the foldable header that you need to hide part of it?

Ordinary people: directly select the area that needs to be hidden, right-[hide]

Master: just let these areas fold up! Like this:

👉 procedure:

❶ select column B, and click "data"-"hierarchical display" to group:

❷ repeats the above steps to establish multiple groups:

Click the number or +-at the top of the table to collapse the header.

If you have mastered the 6 magic weapons made by the Excel meter, when you encounter these problems, you can easily solve them!

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: Zhu Lan, Review: Madge Goose, Editor: er Dong, 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.