| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Rows
In an adjoining column, enter 1 in the first cell and 2 in the second cell.
Copy those two cells. Select from the first cell down until you have 4000 cells selected.. Paste the data - you will have 1 & 2 repeated all the way down. Sort using the new column as the key. Clear the new column. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Paul_of_Abingdon" wrote in message I have an excel file with 2000 records. Is there anyway I can insert blank rows after each records? |
| 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 offsets to working rows across two worksheets | Setting up and Configuration of Excel | |||
| Adding Rows | Excel Discussion (Misc queries) | |||
| adding ROWS | Excel Discussion (Misc queries) | |||
| adding rows | Excel Discussion (Misc queries) | |||
Threaded Mode
