Jumping reference cell in dependent cell formula

[jpeterspro]

Let's say I want cells E1:E10 to be the same as A1:E10. I insert formulas by
putting =A1 in cell E1, =A2 in cell E2, and so on and it works nicely until I
shift data down one cell using copy and paste in column A to add in a new
piece of data. Upon doing this now cell E1=A2 and so on. How can I keep the
formulas from changing?

 

[Stephen]

Let's say I want cells E1:E10 to be the same as A1:E10. I insert formulas
by
putting =A1 in cell E1, =A2 in cell E2, and so on and it works nicely
until I
shift data down one cell using copy and paste in column A to add in a new
piece of data. Upon doing this now cell E1=A2 and so on. How can I keep
the
formulas from changing?

Why not insert a new row for your new piece of data, rather than moving the
old data?