| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping Formulas the same when inserting columns
I have a spreadsheet where colum B is =AVERAGE(C2:H2) , which is the average
of 6 weeks of data. Every week I'll insert a new column at C. I want the formula in column B to always be what is above, however, when I insert a new column Excel thinks for itself and changes the formual in B to =AVERAGE(D2:I2). Does anyone know how to keep the formula to always read the cell reference that is listed in there? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting new row but keeping formulae | Excel Worksheet Functions | |||
| Adding columns w/new formulas BUT keeping subtotals | Excel Discussion (Misc queries) | |||
| Help with keeping formulas in place! | Excel Discussion (Misc queries) | |||
| Inserting Columns and Formulas updating | Excel Worksheet Functions | |||
| Formulas: Keeping same row/column reference when columns are inser | Excel Discussion (Misc queries) | |||
Threaded Mode
