Super table is a powerful table tool. It is different from ordinary tables and has functions such as automatic fixed titles, unified format, one-click summary and intelligent filtering. Below we'll detail how to use these features.
First,select the data range to be converted into a table in the workbook, and then click the "Table" button under the "Insert" tab.
Alternatively, you can use the shortcut key "Ctrl+T" to convert the selected area into a super table.
In smart tables, column headers automatically appear at the top as you scroll down, but once you exceed the table area, the first row no longer appears.
When you add new rows and columns to a smart table, the table automatically expands to include the data while maintaining the original format.
Check the "Summary Row" checkbox under the "Table Tools" tab to automatically add a summary function to the last row of the table. Click on the cell in the summary row, and a drop-down menu will appear on the right, from which you can choose multiple summary methods.
Click "Insert Slicer" under "Table Tools" and select the column headers that need to be filtered to create a filter area. Click any heading in the slicer and the smart table will instantly display the data under that heading.
In addition, there are a variety of border styles to choose from that can be easily applied to your table with one click.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/da-zao-zhi-neng-biao-ge-de-shi-yong-ji-qiao.html
评论列表(196条)
测试