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?