Exel 97

  • Thread starter Thread starter Ric D
  • Start date Start date
R

Ric D

Is there an quick way to delete every other row in a
speadsheet. The problem is every other row is blank and
the sheet has thousands of rows.
Thanks
 
Ric, here is one way, Select the column of data, do Edit / Go To / Special /
Blank cells, Then do Edit / Delete Entire Row

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Back
Top