I am trying to copy a series of cells within the same colum and paste within
that same colum without changing the formula....whenever I paste it changes
the formula to match the cells that I am pasting it in.
For example:
A4=sum(A1:A4)
I want to past this formula into A5 where it still reads (A1:A4)

I know that I am making this harder than it needs to be!
Please help