当前位置：网站首页>Excel delete blank lines

Excel delete blank lines

2022-07-26 08:34:00 【ZenPower】

Use scenarios ：

When you want to filter a column , Because there is an empty line in the data , Content divided by blank lines cannot be filtered , At this time, you need to delete the blank line first , And then screen

  • There is an empty line in the filter content

  • At this time, the filter cannot contain all the contents

  • adopt ctrl+g, Turn on Positioning , choice “ Location condition ”

  • choice “ Null value ”, determine

 

  • The blank line will be selected , Right click on any blank line , Delete

 

  • Choose Delete “ The whole line ”, determine

 

  • After deleting empty lines , Screening again , When you find it, you can choose all the contents

原网站

版权声明
本文为[ZenPower]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/201/202207181752354830.html

边栏推荐

猜你喜欢

随机推荐