:Create groups in the table to display data grouped more clearly-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. Create groups in the table to display data grouped more clearly

Create groups in the table to display data grouped more clearly

Author: daogeziyuan • • Table skills • Views 778
  • Image and text skills


I often encounter long data reports at work.

Group display of table data allows us to observe and organize data more intuitively.


0.gif


分界线.png

▪The table contains sales volume and totals for three months, which is very inconvenient to view.

Select the May date range, click the data tab above - Create Group, its shortcut key is Shift+Alt+Right.

The "Create Group" dialog box will pop up, select "OK". It should be noted that needs to be between "group" and "group" separated areas.


1.gif


▪Click "Hide detailed data" to hide it;Click"Show detailed data" can display it.


2.gif


▪Similarly, we can also create groups based on column data of the table.

Click the Data tab - Create Group, and select "Column" in the dialog box, so that you can create data groups by columns.


3.gif


▪How to cancel the grouping of tables?

Position the cursor in the data area where you want to clear the grouping, click the data tab - Ungroup, its shortcut key is Shift+Alt+Left.

This way you can cancel the data grouping of the table.


4.gif

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/zai-biao-ge-zhong-chuang-jian-zu-shu-ju-fen-zu-xian-shi-geng-qing-xi.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu HUA、先生 Columnist
48 196
single-end

Related Suggestion