| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto update formula when inserting additional columns
Formula covers columns G thru L = formula in column M Ex. =Sum(G1:L1)
Insert columns M thur S -- formula now in column T Ex. should read =Sum(G1:S1) Column T Formula will not automatically update to include columns M thru S Version Excel 2003 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically update formula (sum) when inserting row | Excel Discussion (Misc queries) | |||
| cell ref in function formula change when inserting additional colu | Excel Worksheet Functions | |||
| How can a formula in a cell automatically update when inserting a. | Excel Worksheet Functions | |||
| Auto Update upon shifting, inserting or deleting | Excel Worksheet Functions | |||
| Auto update entire columns / rows??? | Excel Worksheet Functions | |||
Threaded Mode
