- Posts: 1
- Thank you received: 0
deleting multiple rows
- Topic Author
6 months 1 week ago #3532 by tantalum71
deleting multiple rows was created by tantalum71
Hello, I am trying to remove specific row containing “-air” in column “Article Title”, and I follow your video at [url]How to remove rows based on cell value in Excel?[/url] .[img]file:///C:/Users/ipsil/AppData/Local/Temp/msohtmlclip1/01/clip_image002.jpg[/img]However, I do not get ALL 48 rows selected (like in your video at time -1:46), but rather 48 cells.[img]file:///C:/Users/ipsil/AppData/Local/Temp/msohtmlclip1/01/clip_image004.jpg[/img]I have to repeat this process 48 times to delete all selected rows. It seems, that I need to change a setting in Excel to enable selection of multiple rows. Do you know how to do it? Thank you in advance, Brian.
Moderators: Excelfans, OfficeFans, Amanda Lee