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

Original title: "Do you know how many cows there are in the Ctrl+T shortcut key in Excel?"

Today, Xiao Wang teacher wants to share a super easy shortcut key "Ctrl + T," which can convert ordinary tables into "super tables." How easy is the converted "super tables" to use? Let's see it together!

1, ordinary table to super table First, we need to convert the ordinary table to super table, the cursor positioned anywhere in the table, and then use the shortcut key "Ctrl + T" can be converted successfully. Of course, you can also click "Start"-"Style"-"Apply Table Format" to select a style, which can also be converted into a super table.

2, a key to beautify the ordinary table into a super table, we can in the "design"-"quick style", a key to choose their favorite table style.

3. The self-contained filtering super table comes with filtering function, which is convenient for us to filter data.

4. Freeze the first row. Don't worry about dragging the table down. You can't see the header information. You don't need to set anything extra. The super table directly comes with the function of freezing the first row. It's very convenient!

5, quick selection Move the cursor to the first row or column of the table, the cursor will become a black arrow, click, you can quickly select the entire row or column of the table, rather than the entire worksheet row, column!

6, automatic expansion at the end of the new data added, you will find that the super table will automatically expand, colors and styles will automatically fill the table behind, completely do not need us to manually set the colors and styles.

7, automatically switch to the next row in the cell after entering the data, we can press the "Tab" key, switch to the next cell, even at the end of the row, but also can jump directly to the first cell of the next row, is not very user-friendly?

8. Supercomputing Click Design-Table Style Options and check Summary Row. At this time, a Summary row will be added at the bottom of the table. Each cell in the summary row has a drop-down option, which includes averaging, counting, numerical calculation, maximum value, minimum value, etc... It helps us calculate quickly.

9, automatic fill formula Just enter the formula in one of the cells, and all other cells will be automatically filled with the formula.

In the super table, we can also use the "slicer" function, the slicer can generate multiple option buttons, which can help us filter the data and let us see the data more clearly.

This article comes from Weixin Official Accounts: Word Alliance (ID: Wordlm123), author: Wang Qi

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.