如果单元格包含字符串X,则删除整行 [英] Delete entire row if cell contains the string X
问题描述
none
。该表包含5000多个记录,这将节省大量的时间。 感谢任何建议。非常感谢提前!
http://i39.tinypic.com/ 5ano1d.png
这不是一个VBA任务 - 这个特定的任务是最简单的自动过滤器。 / p>
1.插入自动过滤器(在Excel 2010中单击主页 - >(编辑)排序和过滤器 - >过滤器)
2.过滤'网站'栏
3.标记'无'并删除它们
4.清除过滤器
I am new to VBA and I am trying to come up with a way to delete all rows (and shift cells up, if possible) where the website column cell contains the word none
. The table contains 5000+ records and this would save me a great amount of time.
I appreciate any suggestions. Many thanks in advance!
http://i39.tinypic.com/5ano1d.png
This is not a VBA task - This specific task is easiest sollowed with Auto filter.
1.Insert Auto filter (In Excel 2010 click on home-> (Editing) Sort & Filter -> Filter)
2. Filter on the 'Websites' column
3. Mark the 'none' and delete them
4. Clear filter
这篇关于如果单元格包含字符串X,则删除整行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!