Adding blank rows between series of row

**Shadmani** · 05-10-2010, 01:24 AM

Hi Geeks,

will it be possible to add one row between each row across series of rows ?

Thanks

**royUK** · 05-10-2010, 01:27 AM

You can,but you need to attach a workbook or give more information.

Note: if you add empty rows to a table of data you will not be able to use Excel's database features such as AutoFilter,PivotTables, etc

**Shadmani** · 05-10-2010, 01:36 AM

I am sorry, If I was not clear in my earlier request.

Assume I have list of student names from row 1 - 100 with maximum marks - 100
I need to add one more row under each student to fill in actual marks.

is this enough ? If you need to attach the spread sheet.. please let me know

Thanks

**whatsmyname** · 06-22-2010, 10:03 PM

I have an issue similar to this. Except I have rows that may have a cells that contain duplicates. I would like to seperate the duplicate rows(by the specific cell) with a blank row.

Any help is greatly appreciated

Thank you.