Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Use a new column
put in the top part of that column a number series 1 3 5 7 9 etc till all lines with existing data have a number and in the bottom part of that column 2 4 6 8 etc then select the whole range and sort by this new column delete the column after. Greetings from New Zealand Bill Kuunders "cambanis" wrote in message ... Hello everyone! I have a spreadsheet full of data (560x15) and I would like to add one new row bellow each one existing (1120x15). Can I do it? (I can manually select rows one by one having CTRL pressed and then insert Insert Row, but it takes a lot...) Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What is the Excel formula for adding 1 column with several rows? | New Users to Excel | |||
Adding Rows offsets to working rows across two worksheets | Setting up and Configuration of Excel | |||
adding new rows and keeping the same formulas | Excel Worksheet Functions | |||
Adding new rows | Excel Discussion (Misc queries) | |||
adding rows | Excel Discussion (Misc queries) |