| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
formula stays same in cell when new row is inserted
When I insert a new row, I would like to keep the formula in a cell from
moving down. I believe I used to use the $ sign around the cell in the formula, but this no longer works with 2003. |
|
#2
|
|||
|
|||
|
See what Chip Pearson has to say about relative and absolute cell references
http://www.cpearson.com/excel/relative.htm "drandall" wrote: When I insert a new row, I would like to keep the formula in a cell from moving down. I believe I used to use the $ sign around the cell in the formula, but this no longer works with 2003. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula stays displayed in cell | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
| looking for a formula | Excel Worksheet Functions | |||
Hybrid Mode
