Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel spreads
Is it possible to add a blank row under every existing row in excel
spreadsheet without have to right clike and add 2,000 times in 2,000 line speadsheet? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel spreads
For i = Cells(ROws.Count,"A").End(xlUp).Row To 1 Step -1 Rows(i+1).Insert Next i -- HTH RP (remove nothere from the email address if mailing direct) "Geo" wrote in message ... Is it possible to add a blank row under every existing row in excel spreadsheet without have to right clike and add 2,000 times in 2,000 line speadsheet? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel spreads
-in a helper column, add a series of odd numbers 1-3999 to your 2000 rows.
(enter 1,3,5. Select those 3 cells. Grab the bottom right "handle" with right mouse button & drag down to 2000. Select "Fill Series") -in the next (empty) 2000 rows add a series of even numbers 2-4000 -sort on the helper column -delete the helper column -- George Nicholson Remove 'Junk' from return address. "Geo" wrote in message ... Is it possible to add a blank row under every existing row in excel spreadsheet without have to right clike and add 2,000 times in 2,000 line speadsheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
After merging from excel to word i now cant open the excel spreads | Excel Discussion (Misc queries) | |||
Fomulas and calculations are no longer working on my Excel Spreads | Excel Worksheet Functions | |||
Create Microsoft Outlook CalenderEvents from data in Excel Spreads | Excel Programming | |||
Does anyone know how to put a watermark DRAFT on an excel spreads. | Excel Discussion (Misc queries) | |||
Creating a Microsoft Words document from an existing Excel spreads | New Users to Excel |