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

Original title: "5 must know Excel super table tips, you know how many?"

Hi~ Hello everyone, I am Tian Tian who is also learning Excel ~

When it comes to Excel shortcut Ctrl+T, what is the first thing that comes to mind?

Converting super tables? Beautify the form?

If you only know that it is a super table, a one-click beautification table, then I advise you to hurry up to make up for Excel knowledge!

Today I will introduce to you, many people do not know the five major functions of the super watch.

Switch table styles with one click Click "Table Style Options" in the "Table Design Tab" to quickly switch table styles.

Auto-lock header rows When you select a super table, header rows are automatically pinned to column labels.

Automatically summarize data Double-click the bottom edge of any cell to go to the bottom row of the table. Check the "Summary Row" check box in the "Design tab" of the table to automatically add summary rows.

Click on the drop-down triangle to select different statistical methods. When filtering, summary results change based on the filtering results.

Select the last cell of the penultimate row and press TAB to automatically add blank rows to enter data. Select "Summary Row" and click "Split" button under "View Tab" to fix summary row.

Automatically expand the table range and fill the formula Add a unit price column to the right of the table. Enter Title: Unit Price. The scope of the super table is automatically expanded.

Enter = F2 / E2 in the cell, press Enter, and the formula automatically fills the entire column. Fill the summary row formula to the right into the unit price column.

Select any cell of the super table by calling the slicer, click the Insert slicer button in the Table Design tab, and check the three headings of marketer, product and region. Click OK.

Move and arrange the three slicers. Click the "slicer button" to quickly filter and query the super table data.

All right, have you learned all five tricks of superwatch?

Super table function is not very powerful! In fact, Excel has a lot of practical skills, master well can help you easily solve office problems, quickly improve work efficiency oh!

This article comes from Weixin Official Accounts: Autumn Leaf Excel (ID: excel100), author: Tian Tian

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.