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

Do you know how powerful the "super watch" in Excel is? The function can throw off the ordinary form how many blocks, do not believe? Then let's have a look together.

1. How to turn an ordinary table into a super table? Very simple, we just need to position the cursor in the table, and then use the shortcut key "Ctrl + T" to convert a normal table to a super table. Of course, you can also click "start"-"style"-"apply table format", select a style, you can also convert to a super table.

2. After one-click beautification turns an ordinary table into a super table, we can choose our favorite table style with one click in "Design"-"Quick style".

3. The self-filtering super table has its own filtering function, which makes it convenient for us to filter the data.

4, freeze the first row do not have to worry about the table dragging down, do not see the header information, and do not need to set anything additional, the super table directly comes with the first line freeze function, very convenient!

5. Quick selection when you move the cursor to the first row or column of the table, the cursor will become a black arrow. Click to quickly select the entire row or column of the table, rather than the rows and columns of the entire worksheet!

6. Automatic extension when you add new data at the end, you will find that the super table will be automatically expanded, and the colors and styles will be automatically filled into the following table, so there is no need for us to manually set the colors and styles.

7, automatically switch the next row in the cell after the data is recorded, we can press the "Tab" key to switch to the next cell, even at the end of the line, can also directly jump to the next row of the first cell, is not very human?

8, supercomputing click "Design"-"Table style options", check "Summary row", at this time, the bottom of the table will add a "summary" row, each cell of the summary row has a drop-down option, there are averages, counts, numerical calculations, maximum, minimum, and so on. It can help us to calculate quickly.

9, automatic filling formula only need to enter the formula in one of the cells, the other cells will be automatically filled in the formula.

Slicer in the super table, we can also use the "slicer" function, slicer can generate multiple option buttons, can help us filter the data, so that we can see the data more clearly.

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

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.