Deleting double rows

  • Thread starter Thread starter Nic Zun
  • Start date Start date
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
 
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

alternate row shading on filtered data 2
In VBA, How to Refer to Cell In Specific Column But Selected Rows? 7
delete rows between tow inputs numbers 3
Formatting rows 10
How do I maintain alternate row shading after inserting a new row 4
Alternating shading of varying groups of rows 3
Macro to delete rows if... 6
Delete Rows 3

Back
Top