+ Reply to Thread
Results 1 to 3 of 3

Inserting alternate blank rows in Excel

  1. #1
    KopRed
    Guest

    Inserting alternate blank rows in Excel

    I have several spreadsheets with between 2,000 and 3,000 rows of data. I'm
    using them to import data into some accounting software. The format required
    by the software is that each row of data is separated by a blank row. Short
    of individually inserting several thousand rows, does anyone know another way
    of changing the layout of the spreadsheet?

  2. #2
    Barb Reinhardt
    Guest

    Re: Inserting alternate blank rows in Excel

    Well, you could add a helper column and enter 1, 3, 5, and copy down to
    the bottom of what you've got. You could then put 2,4,6,8 ... in blank rows
    until you have the max # of what you need. Then sort by the helper column.
    Make sure you save a pristine copy and operate on a secondary copy so you
    don't damage your good file.

    "KopRed" <KopRed@discussions.microsoft.com> wrote in message
    news:AB025154-629E-42DC-AA0C-5A86376C29DE@microsoft.com...
    >I have several spreadsheets with between 2,000 and 3,000 rows of data. I'm
    > using them to import data into some accounting software. The format
    > required
    > by the software is that each row of data is separated by a blank row.
    > Short
    > of individually inserting several thousand rows, does anyone know another
    > way
    > of changing the layout of the spreadsheet?




  3. #3
    Erin Searfoss
    Guest

    RE: Inserting alternate blank rows in Excel

    Here is a macro you can use. It's loosly written so it may take a minute to
    run if the file is large.
    Copy the code into a module in the Visual Basic Editor (Alt F11 to open
    VBE). Then the macro InsertRows will be available when you select Tools,
    Macro, Macros (or Alt F8).

    Sub InsertRows()

    intRow = Cells.SpecialCells(xlCellTypeLastCell).Row
    For i = intRow To 1 Step -1
    Rows(i).EntireRow.Insert
    Next i

    End Sub

    "KopRed" wrote:

    > I have several spreadsheets with between 2,000 and 3,000 rows of data. I'm
    > using them to import data into some accounting software. The format required
    > by the software is that each row of data is separated by a blank row. Short
    > of individually inserting several thousand rows, does anyone know another way
    > of changing the layout of the spreadsheet?


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1