What I do is -

Click copy on the cell to copy
Hold Ctrl+Shift the press the up arrow until it reached the desired cell, or
just hold the shift key and hit page up until it reaches the desired cell.

Then hit enter or paste.


"Pammy" wrote:

Is there an easy way to copy formulas up without dragging up? I have a
spreadsheet that has 4500 rows of info, I want to add the latest infor at the
top row starting in row 50 each time, but when I insert the info I have to
copy and paste the formula. Easch week I will be adding new info at the top
and I don't want to have to drag the formula if I can keep from it.