Thread: copy formula up
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pammy Pammy is offline
external usenet poster
 
Posts: 96
Default copy formula up

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.