excel super table

There is a kind of table in Excel table called "Super Table". It is super powerful, simple and efficient. It can not only easily manage and analyze data, but also conveniently sort, filter and format data.

For example: it has its own filter, which can quickly summarize statistics and automatically identify the data area range. The formula displays Intuitive column header references, such as "unit price * amount", can also automatically fill in formulas and formats, etc. (Recommended learning: web front-end video tutorial)

1. How to convert an ordinary table into a super table

Method 1 : [Insert] → [Table]

Position the mouse on any cell in the data area, or select the area where you want to set up the super table, [Insert] → [Table] (or press the shortcut key), and the create table will pop up Check the box, the source of the table data will automatically select all table areas, and check the table to include titles by default. Just click OK to turn it into a super table.

Method 2: [Start] → [Apply Table Format]

Position the mouse on any cell in the data area, or select the area where the super table is to be set, [Start] → [Apply Table] Format], select any style, and the Apply Table Format dialog box will pop up. The source of the table data will automatically select all table areas, and check the table to include titles by default. Just click OK to convert it to a super table.

Warm reminder: To check whether it has been set as a super table, you can check it through the two characteristics of the super table: 1. There is an arrow in the lower right corner; 2. Merging cells is prohibited in the table

The above is the detailed content of excel super table. For more information, please follow other related articles on the PHP Chinese website!