https://iknow-pic.cdn.bcebos.com/f9198618367adab4aa120f2e86d4b31c8601e499

2、全選資料，在excel上方的導航欄找到"查詢與選擇"選項，並選擇"定位條件"，調出定位工具：

https://iknow-pic.cdn.bcebos.com/2fdda3cc7cd98d1048101d5c2c3fb80e7aec9092

3、在彈出的定位條件的對話方塊中，選擇“空值”選項，如圖：

https://iknow-pic.cdn.bcebos.com/b21bb051f8198618ea19f9e947ed2e738bd4e605

https://iknow-pic.cdn.bcebos.com/11385343fbf2b211a0779423c78065380cd78e05

https://iknow-pic.cdn.bcebos.com/caef76094b36acaf6b99879171d98d1001e99c65

6、最終效果如下：

https://iknow-pic.cdn.bcebos.com/d009b3de9c82d158bb3248dc8d0a19d8bc3e422e