Delete every other row

  • Thread starter Thread starter Kathy
  • Start date Start date
K

Kathy

Is there a way to enter a command that will completely
delete every other row?
Thanks
(e-mail address removed)
Kathy
 
One way:

1. Select a range in an open column (say rows 1-500).
2. Enter: =IF(MOD(ROW(),2)=0,1,"e") and press
<ctrl><enter>.
3. Press F5.
4. Special > Formulas and uncheck each box
except "Number" (or "Text", depending on which rows you
wish to delete).
5. Press <ctrl><->
6. Select "Delete entire row".

HTH
Jason
Atlanta, GA
 
Back
Top