Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inserting columns within certain rows only | Excel Discussion (Misc queries) | |||
Automatically inserting rows | Excel Worksheet Functions | |||
Inserting Rows w/formulas question | Excel Worksheet Functions | |||
inserting rows through external data source | Excel Discussion (Misc queries) | |||
Inserting Multiple Rows with Formulas | Excel Worksheet Functions |