Note: The other languages of the website are Google-translated. Back to English
Log in  \/ 
x
or
x
Register  \/ 
x

or
×

filedeleting multiple rows

More
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. 

This browser does not support PDFs. Please download the PDF to view it: Download PDF

Attachments:

Please Log in or Create an account to join the conversation.

Moderators: ExcelfansOfficeFansAmanda Lee