Excel automating next line

Just complete all your data down the row without the formula. Then in the first formula row, put your cursor down right which will make your cursor thinner, then double click the thin cursor. It will automatically copy the first formula down . Note that this will only be applicable to continuous data at your left. If there is a space, it will stop there.

Just complete all your data down the row without the formula. Then in the first formula row, put your cursor down right which will make your cursor thinner, then double click the thin cursor. It will automatically copy the first formula down . Note that this will only be applicable to continuous data at your left. If there is a space, it will stop there.

I tried this, maybe I didnt do it right, but it didnt work. However, even if it did work, there is data between cells with formulas.

I can simply copy the forulas, but the person entering the data is not good with excel, I wanted to make say a macro, where it would simply copy the formulas down one. I just dont know how to do it, or if there is a better way

If you want a macro put this in a the sheet code by right clicking the tab sheetname below left.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim xrange As Range
If Target.HasFormula Then
Application.EnableEvents = False
If Target.Column > 1 Then
Set xrange = Target.Offset(0, -1).End(xlDown).Offset(0, 1)
Range(Target, xrange).FillDown
Application.EnableEvents = True
End If
End If
End Sub

I think what u need is, after u input the data in a row, u want that excel will automatically creates another row with the same formula... until you finished inputting?
And if you dont want to add another data to add in a row, excel will not create a row with formula in it?

I dont think this can be create but, chitosunday is right just use the FILL HANDLE to copy the formulas for each column. Lock these formula so that no body could erase or edit this formula of yours.