Replacing several rows
Hi all...
I have a form that I imported into Excel. There are rows that are repeated
throughout the worksheet that I want to delete (think of them as headers or
footers). I believe the text in each row I want to delete is the same, and
they are a continuous block (for example, rows 5-10, 21-26, 36-41, etc).
How can I select the text and tell Excel to delete all rows with that text?
thanks for any help you can throw my way.
john
|