数据表格处理 Data table processing

gaowenhua

SUM求和函数想必大家都很熟悉，但若想要对不同行列或指定区域的单元格进行求和，使用AIt+即可一秒搞定求和

                               
登录/注册后可看大图

gaowenhua

The SUM summation function is probably familiar to everyone, but if you want to sum cells in different rows, columns, or specified areas, you can use AIt+to do it in one second

gaowenhua

批量删除空白行，Ctrl+G，选择定位条件-空值，然后右键删除即可

                               
登录/注册后可看大图

gaowenhua

Batch delete blank rows, Ctrl+G, select location condition - null value, then right-click to delete

gaowenhua

批量添加邮箱后缀，在类型中输入@"@com"

                               
登录/注册后可看大图

gaowenhua

Batch add email suffixes, enter @ "@ com" in the type field

gaowenhua

批量修改图片尺寸有时候，如果添加到表格里的图片大小不一，你只要「点击开始」-「查找」-「定位」，在弹出的对话框中选择「对象」，再在「图形工具」-「高度和宽度」处修改数值，就可以批量修改表格中的图片大小了

                               
登录/注册后可看大图

gaowenhua

Sometimes, when changing the size of images in bulk, if the images added to the table have different sizes, you just need to "click start" - "search" - "locate", select "object" in the pop-up dialog box, and then modify the values in "graphic tools" - "height and width" to batch change the size of the images in the table

gaowenhua

一键找不同并去重，选中需筛选的数据区域，点击菜单栏「数据」里的「高亮重复项」，点击“确定”，即可看到被橙色高亮的重复数据

                               
登录/注册后可看大图

gaowenhua

One click to find and remove duplicates, select the data area to be filtered, click on "Highlight Duplicate Items" in the "Data" menu bar, click "OK", and you will see the duplicate data highlighted in orange