View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
 
Posts: 510
Default Keep formula fixed

use $ in the cell references and they won't change, like $a$1 instead of a1

"Oldjay" wrote:

I want to keep a formula the same even if I move one of the cells that it
referenced.