inserting rows
 

is it possible to insert rows at a regular intervals by using one command?
like i have to insert rows after odd rows number....1,3,5,....

thanks

Ankur,

Insert a new column, and use the formula:

=ROW()

and copy to match your table.

Then below your table, in the same column, insert a 1 in the first cell (or the number of your
lowest numbered odd row in your table), then below that the formula
=??+2
where you replace the ?? with the cell address of the cell with the 1. Then copy down that formula
until a number matches your highest row number.
Then copy that column, and pastespecial values to convert to values. Then select your table and the
new column (including the blank cells below your table - in other words, everything), and sort based
on that column. Then delete the column, and you will have a blank row below each of what used to be
odd numbered rows.

HTH,
Bernie
MS Excel MVP


"Ankur" wrote in message
...
is it possible to insert rows at a regular intervals by using one command?
like i have to insert rows after odd rows number....1,3,5,....

thanks