What are the characteristics of Excel super table

This article mainly introduces the characteristics of Excel Super Table, which is very detailed and has a certain reference value. Friends who are interested must read it!

Before we talk about the features of a super table, let's take a look at how to turn a normal table into a super table. Here are two ways to turn a normal table into a super table.

① select data, key combination ctrl + t, generate super table ② click start-> apply table format-> choose any format

Now that the ordinary watch has become a super watch, let's learn the unique features of the super watch.

1) built-in filtering function

The super table has its own filtering function. We know that if you want to set the filtering function to a normal table, you need to click on the data-> filter.

2) it has the function of freezing the first line

For regular tables, if you drop down the data, it will cover your header, and sometimes you don't know what each column represents. But the super table is different, it comes with the function of freezing the first row, and if you drop down the data, you can still see the header.

3) built-in automatic data extension function

In the last row of the super table, when new data is added, the super table will automatically expand, including colors and styles will also be automatically populated to the later table.

4) comes with the function of automatically switching to the next cell

In fact, a normal table with this function can also use the tab key to switch data to the next cell. The only difference is that when the super table reaches the end of each row, after using the tab key, it will switch to the next row, but not the normal table.

5) built-in automatic summarization function

This is a very useful function of the super table, and you can choose the appropriate summary method according to the data characteristics of each column.

6) the function of self-filling formula

In a regular table, after we enter a formula in one cell, we need to drop down before we can let other cells fill in the formula. But it is different for the super table, after we fill in the formula for a certain cell, the following cells will be filled in automatically.

7) the super table has the function of inserting the slicer

It has the function of inserting the slicer, which makes it more convenient for us to filter the data.

These are all the contents of the article "what are the features of the Excel Super Table?" Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!