Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Adding new rows
I have a spreadsheet with 100 rows in, I need to add a row after each current row, is there a quick way to do this or have i got to insert each new row individually? -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=390760 |
#2
|
|||
|
|||
I assume you want to add an empty new row in between the existing rows.
One way would be with an extra column Save as "trial" first.......just in case things get muddled up. Give the existing rows uneven numbers and underneath them the same number of rows with even numbers copy and extend any required formula's do a sort on the added column with the numbers -- Greetings from New Zealand Bill K "Paul Sheppard" wrote in message news:Paul.Sheppard.1sumed_1122501923.8656@excelfor um-nospam.com... I have a spreadsheet with 100 rows in, I need to add a row after each current row, is there a quick way to do this or have i got to insert each new row individually? -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=390760 |
#3
|
|||
|
|||
Thanks Bill great tip, and it is really quite simple if you think about it -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=390760 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding five new rows every 40 rows in a spreadsheet? | Excel Discussion (Misc queries) | |||
adding rows to pivot table | Excel Discussion (Misc queries) | |||
Adding summaries, rows and pre-population | New Users to Excel | |||
Adding Rows to Master Sheet | New Users to Excel | |||
Adding rows to an array | Excel Worksheet Functions |