| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
mantaining formula when inserting col
Simple example:
C3 = B3+1 Insert a new column C; old col C changes to .. D3 = B3+1 (where col D was col C) A similar thing occurs if I copy col C, and 'insert copied cells' at col C. Then, I get ... C3 = A3+1 D3 = B3+1 What I'd like is to maintain the relative offset .. C3 = B3+1 D3 = C3+1 Thanks, George |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide formula | Excel Worksheet Functions | |||
| adding row to forumla | Excel Discussion (Misc queries) | |||
| Formula changes while inserting a row !!!! | Excel Worksheet Functions | |||
| Hidden Columns are unhidden when inserting a Formula | Excel Discussion (Misc queries) | |||
| Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Threaded Mode
