Thread: How do I enter a new row every 12 rows in a very large spreadsheet
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Cone Jim Cone is offline
external usenet poster
  
Posts: 3,290
Default How do I enter a new row every 12 rows in a very large spreadsheet
Maybe simpler...
In the adjoining column enter 12.1, 24.1, 36.1 in the first three cells.
Select the three cells and fill down to about 350 rows below your data.
(4000/12 =333)
Select both columns and sort by the new column.
Clear the new column.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Sarah"

wrote in message
I have about 4000 rows and need a new, blank row every 12 rows.
Reply With QuoteReply With Quote