Inserting empty rows

[karenff]

I have a spreadsheet with rows 3 through 92 populated with data and I’d like to put an empty row in between each of the populated rows. Is it possible to do this in one step, without manually adding a row 90 times, over and over?

[mikeTRON]

So you can manually select each row by clicking on the row number on the left of the spreadsheet. Once all of the rows are selected you can hit CTRL+Shift+"+" or just INSERT ROWS as normal and that would work.

Otherwise you can use VBA to fairly simply do this as well.

[Richard Buttrey]

Hi,

The easiest way without resorting to a macro would be to use a helper column. e.g. column E
In E3 enter the value 1, then in E4 copied down to E92 enter

Please Login or Register  to view this content.

now in E93 enter the value 4 and in E94 copied down to E183 enter

Please Login or Register  to view this content.

Now select the data from rows 3:183 including your helper column E and sort ascending using the helper column as the key

[mikeTRON]

If you want to use VBA:

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

[Amanda Wilso]

You can create the blank rows separately and then interleave them with the existing rows by sorting. To start, insert a new column to the left of the existing column A. Enter 1 in cell A1 and highlight column A all the way to the last row that contains data. From the Edit menu select Fill | Series and click on OK. Column A should now contain numbers from 1 to the total number of rows. Press Ctrl-C to copy these cells to the clipboard, click in the cell just below the last of them, and press Ctrl-V to paste. Now highlight the entire data area, including the new rows with just a number in column A. Select Sort from the Data menu and choose the No header row option in the resulting dialog box. Under Sort by select Column A, under Then by select column B, and click on OK. Finally, delete column A