Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

If all rows to delete have "shopping cart" and only those have it.

Go to the top-left cell of data range or select the data range with their headers.

Menu/Data/Filter/Autofilter.

In the header with "shopping cart" field click the arrow and select only "shopping cart".

Click on the top(row numbers)-left(column numbers) box, this select all rows an columns.

Click on the number of header row for deselect.

Right-click on any other row number and select delete rows.

Go again to the filter and select All.

Of course you can filter by other fields or use the Standard filter (with optional regular expression).