Assuming you just need to do this once, but have a bunch of rows to delete
(say 1000+), it can be a pain to select every other row. So, here's a
simple one-time trick.

1. Insert a temporary column as Column A
2. In this temporary Column A, flag all rows you want to delete with a "1"
value
- To do this, simply use a formula such as this:
Cell A2 = "1"
Cell A3 = ""
Cell A4 = A2
Cell A5 = A3
...
- Copy this formula all the way down -- you'll end up with a "1" in
every other row.
3. Sort the worksheet based on Column A, so all of the flagged rows will be
grouped together
4. Select all of the grouped rows and delete.


"MacK" wrote in message
...
Thank you, Michael. I'll try your suggestion of clicking on the row
headers;
but, as I told Fredrik, I guess I'll have to learn what a macro is. Thanks
again.

"Michael" wrote:

Hi Mack
If this is a one off, Click on the first row header, then Hold Ctrl and
click on all of the other row headers and then delete them.
If you are going to do it on a regular basis you would be better to
create a
Macro.

HTH
Michael

"MacK" wrote:

How can I delete every other row on an Excel worksheet without
highlighting
and deleting each row in turn?
--
MacK