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?