Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I lock cell formulas???
You could use the OFFSET fuction.
In C1 enter: =OFFSET(C1,0,-1)+OFFSET(C1,0,-2) This adds the cells that are 1 column and 2 columns to the left of C1. When you insert a column, the formula will be moved to D1, but still add the cells that are 1 and 2 columns to the left. HTH, Elkar "John - Menifee, CA" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I lock cell formulas???
Thanks. Never used that fuction before. Still learning.
"Elkar" wrote: You could use the OFFSET fuction. In C1 enter: =OFFSET(C1,0,-1)+OFFSET(C1,0,-2) This adds the cells that are 1 column and 2 columns to the left of C1. When you insert a column, the formula will be moved to D1, but still add the cells that are 1 and 2 columns to the left. HTH, Elkar "John - Menifee, CA" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing cell references in formulas to names and back again. | Excel Discussion (Misc queries) | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Dates of a Day for a month & year cell formulas | Excel Discussion (Misc queries) | |||
How to lock a row in a spreadsheet based on the value in a cell | Excel Worksheet Functions | |||
Problem with formulas changing cell reference | Excel Discussion (Misc queries) |