View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John - Menifee, CA
 
Posts: n/a
Default How do I lock cell formulas???

For example, formaula is cell C1 adds cell A1 and B1. If I insert column
between B1 and C1, the formule will shift to D1. How do I make D1 formula add
cells B1 and C1 automatically. D1 currently will continue to add A1 and B1.