I have a standard list in Excel and I want to insert multiple alternate
blank rows automatically so that these rows can be used for additiional data
at a later stage.
Can anyone offer advice as to how this can be done?
Thanks in advance.
I have a standard list in Excel and I want to insert multiple alternate
blank rows automatically so that these rows can be used for additiional data
at a later stage.
Can anyone offer advice as to how this can be done?
Thanks in advance.
Hi
I don't know how it can be done, but you might like to consider an alternative method of entering the extra data in columns alongside the respective rows - this way your data is future proof against ever needing to handle it as some sort of database - there have been a lot of posts lately that demonstate how difficult single columns of mixed but related data are to split into separate records should you ever need to do so.
Julia
Phil
"Automatic" requires VBA code.
Sub InsertALTrows()
'David McRitchie, misc 2001-06-30
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Dim i As Integer
For i = Selection(Selection.Count).Row To Selection(1).Row + 1 Step -1
Rows(i).EntireRow.Insert
Next i
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub
If not familiar with VBA and macros, see David McRitchie's site for more on
"getting started".
http://www.mvps.org/dmcritchie/excel/getstarted.htm
In the meantime..........
To create a General Module, hit ALT + F11 to open the Visual Basic Editor.
Hit CRTL + R to open Project Explorer.
Find your workbook/project and select it.
Right-click and Insert>Module. Paste the above code in there. Save the
workbook and hit ALT + Q to return to your workbook.
Run the macro by going to Tool>Macro>Macros.
Gord Dibben Excel MVP
On Tue, 19 Apr 2005 06:55:03 -0700, "Phil A." <Phil
[email protected]> wrote:
>I have a standard list in Excel and I want to insert multiple alternate
>blank rows automatically so that these rows can be used for additiional data
>at a later stage.
>
>Can anyone offer advice as to how this can be done?
>
>Thanks in advance.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks