help on deleting several rows at once
Manually:
Insert a new column (column A).
Put X in A1
Put Y in A2
Select A1:A2 and rightclick and drag down.
let go and choose copy.
Apply Data|filter|autofilter and show only the rows you want to delete.
select those visible rows and rightclick|delete|entirerow
Remove the autofilter and delete your helper column.
hsg wrote:
I wish to delete multiple, non continuous rows at once. When such rows are
selected, it says "This operation can not be performed on multiple objects".
The rows in question run into hundreds, say I would like to delete all even
rows, or every third row from ROW 1 onwards
can you please help
--
Dave Peterson
|