:Tutorial for beginners on tables: How to delete blank rows in tables in batches-Table skills免费ppt模版下载-道格办公

Tutorial for beginners on tables: How to delete blank rows in tables in batches

Picture and text skills

When you encounter blank rows in the table, are you still deleting them one by one?

Use this shortcut to delete all blank rows in the table at once.

图文对齐图.png

▪Method 1: Use positioning tools

Step 1: Click the search drop-down button under the "Start" tabClick to locate, you can also Use the key combination "Ctrl+G" to bring up the positioning dialog box.

录制_2021_03_25_11_40_13_580.gif

Step 2: In the positioning dialog box, select the positioning condition to be empty.You can see All blank lines are selected, right-click-delete-the entire line.

录制_2021_03_25_11_42_57_252.gif

▪When there are both blank rows and blank cells in the table, can be usedCOUNTA function.

Step 1: Create a new auxiliary column on the right side of the table,ClickC2 cell,Then enter in the "Name box""C2:C15"

Press Enter to select the data column.

录制_2021_03_25_11_44_19_701.gif

Step 2: Enter "=COUNTA(A2:B2)" in the formula bar Then press The "Ctrl+Enter" keys fill all.

录制_2021_03_25_11_45_19_93.gif

Step 3: Click the "Filter" button under the "Home" tab,Change the value to Filter out the 0 rows and delete them.

录制_2021_03_25_11_46_13_44.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/biao-ge-xin-shou-jiao-cheng-ru-he-pi-liang-shan-chu-biao-ge-kong-bai-xing.html