Exel 97

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
 
P

Paul B

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 **
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Indenting every other paragraph in Word at the same time? 0
Dealing with a Pivot Table (when I don't want to) 0
Blank Page After Envelope-Label Wizard 5
Cell data entering slow! 0
How do I set focus (and select text) on a text box on a modeless userform? 0
macrio soft exel 2
MS Word normal.dot cannot be fixed 'text box' appears each time 4
Macro to select and delete levels of a document 2

Top