Deleting double rows

N

Nic Zun

I have a spreadsheet with which I wish to split in two (or delete alternate
rows). Imagine banded rows with every second shaded row to be moved into
another worksheet with the unbanded or unshaded rows remaining.

Any suggestions on how to do this?

Thanks in advance.
Nic
 
S

Stefi

In Excel2003:
Enter this formula in row 1 in an empty helper column and fill it down as
required:
=MOD(ROW(),2)=0
Apply Autofilter to the helper column and select TRUE as filtering criterium.
Select visible rows and Copy
Paste in a new sheet
Go back to the original sheet
select FALSE as filtering criterium
Select visible rows and Delete rows

Regards,
Stefi


„Nic Zun†ezt írta:
 

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

Formatting rows 10
Easiest Way to Delete Rows 4
Delete Rows 3
Deleting rows containing zeros 2
Deleting blank rows with formulas in them 7
Deleting/removing unused rows in a worksheet 3
Deleting Blank Rows. 3
Automatically delete blank rows 4

Top