insert blank rows

  • Thread starter Thread starter sillyscorpio
  • Start date Start date
S

sillyscorpio

how do I insert rows so that every other line is blank into a worksheet the
shortest way , the worksheet is long
 
It's not very hard...
In a blank column, enter consecutive numbers from the top
of your data to the bottom. (enter 1 and 2 in the top two cells and fill down).
Copy the newly entered numbers and paste them directly below
the numbers you just created.
Select your data and include the new column.
Sort your data using the new column as the key.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"sillyscorpio"
wrote in message
how do I insert rows so that every other line is blank into a worksheet the
shortest way , the worksheet is long
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert blank row after change in cell value not working. 1
Need Macro- Insert rows based on dates and copy info from that row 1
Formula from consecutive rows to alternate rows? 2
Deleting blank rows with formulas in them 7
Insert blank rows 2
Inserting blank rows in Excell 6
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
How do i insert blank rows between data that is thousands of rows 5

Back
Top