current position:Home>9 applications of super tables in Excel worksheets, which are convenient and practical, and double the efficiency

9 applications of super tables in Excel worksheets, which are convenient and practical, and double the efficiency

2022-11-24 19:41:12Pengyou

Excelof the supersheet in the worksheet9个应用,方便实用,效率翻番


Excel中的工作表,大家都不陌生,It's in the workbookSheet1、Sheet2……等,但提高“超级表”,Not all parents know it,今天,小编通过9application skills,来揭开Excel工作表中“超级表”的神秘面纱.


一、Excel 超级表:将普通表转换为超级表.

Excel超级表It refers to a form that can quickly summarize and process massive amounts of data.

Excelof the supersheet in the worksheet9个应用,方便实用,效率翻番


方法:

Position the cursor in the data source area,快捷键Ctrl+T或者【开始】-【样式】-【套用表格样式】来完成转换.

解读:

If the data source contains“表头”等部分,You need to select the data source area.


二、Excel 超级表:一键美化.

目的:对新插入的ExcelOne-click beautification of the super table.

Excelof the supersheet in the worksheet9个应用,方便实用,效率翻番


方法:

选择ExcelAny range of cells in a supersheet,选择Excel超级表的【设计】工具,选择【表格样式】Other styles in the .


三、Excel 超级表:筛选数据.

目的:Filter by Marriage Status“未婚”的人员信息.

Excelof the supersheet in the worksheet9个应用,方便实用,效率翻番


方法:

单击标题栏【婚姻】右下角的箭头,选择【未婚】即可.

解读:

ExcelThe super table has its own data filtering function,无需通过【数据】-【筛选】Functionality to add filter buttons.


四、Excel 超级表:冻结首行.

目的:冻结ExcelThe first row of the worksheet,Easy access to data.

Excelof the supersheet in the worksheet9个应用,方便实用,效率翻番


方法:

Move data directly,The header row content can be displayed at the column header.

解读:

If the data source area contains “表头”等内容,则需要删除“表头”Wait or follow【视图】-【冻结窗格】的方法来操作.


五、Excel 超级表:快速选中.

目的:快速选中ExcelThe entire row of the hypertable(列).

Excelof the supersheet in the worksheet9个应用,方便实用,效率翻番


方法:

Move the cursor to the line(列)标题处,Wait until the cursor changes to the right(下)black arrow,Just click or drag.


六、Excel 超级表:自动扩展.

目的:添加新行(列).

Excelof the supersheet in the worksheet9个应用,方便实用,效率翻番


方法:

In the last line of the original data area(列)Just add new content.

解读:

New line added(列)自动填充到Excelsuper table area,无需重新设置.


七、Excel 超级表:Automatically switch to the next range of cells or row.

目的:数据数据时,按下Tabkey to automatically switch to the next column or row.

Excelof the supersheet in the worksheet9个应用,方便实用,效率翻番


方法:

Enter content in the cell area,并按Tab键.

解读:

If the current range of cells is notExcel Super last column,按下Tab键后,Automatically switch to the next column,如果为最后一列,It will automatically switch to the next line.


八、Excel 超级表:自动统计.

目的:Quick statistical analysis of data.

Excelof the supersheet in the worksheet9个应用,方便实用,效率翻番


方法:

单击ExcelAny range of cells in the supersheet range,选择Excel超级表的【设计】工具,【表格样式选项】-【汇总行】.

解读:

Data are summarized except for the commonly used mean、计数、数值计数、最大(小)值、In addition to functions such as summation,还可以使用【其他函数】Function to complete more statistical analysis functions.


九、Excel超级表:自动填充公式.

目的:Conduct sales to employees“合计”.

Excelof the supersheet in the worksheet9个应用,方便实用,效率翻番


方法:

在“合计”Enter the formula in any cell range of the column,The other cell ranges in this column are automatically filled.


十、Excel 超级表:切片器.

目的:Filter the data as needed.

Excelof the supersheet in the worksheet9个应用,方便实用,效率翻番


方法:

选定ExcelAny range of cells in a supersheet,选择Excel超级表的【设计】工具,选择【工具】组中的【插入切片器】,调整位置,Select the desired value as needed.


十一、Excel 超级表:转换为普通表.

目的:将ExcelHyper tables are converted to normal tables.

Excelof the supersheet in the worksheet9个应用,方便实用,效率翻番


方法:

选定ExcelAny range of cells in a supersheet,选择Excel超级表的【设计】工具,选择【工具】组中的【转换为区域】-【是】即可.

copyright notice
author[Pengyou],Please bring the original link to reprint, thank you.
https://en.fheadline.com/2022/328/202211241919216978.html

Random recommended