| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting double rows
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 -- I don''t Excel at Excel |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Deleting double rows
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: 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 -- I don''t Excel at Excel |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Deleting double rows
Thanks very much Stefi - works well!!
Cheers, Nic -- I don''''t Excel at Excel "Stefi" wrote: 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: 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 -- I don''t Excel at Excel |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Deleting double rows
You are welcome! Thanks for the feedback!
Stefi €žNic Zun€ť ezt Ă*rta: Thanks very much Stefi - works well!! Cheers, Nic -- I don''''t Excel at Excel "Stefi" wrote: 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: 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 -- I don''t Excel at Excel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro for deleting rows and serialising the remaing rows | Links and Linking in Excel | |||
| Macro for deleting rows and serialising the remaing rows | Setting up and Configuration of Excel | |||
| Macro for deleting rows and serialising the remaing rows | Excel Worksheet Functions | |||
| Help!! I have problem deleting 2500 rows of filtered rows!!!! | Excel Discussion (Misc queries) | |||
| deleting hidden rows so i can print only the rows showing?????? | Excel Worksheet Functions | |||
Hybrid Mode
