| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to stop to adjust references automatically
I would like to know how to stop excel from adjusting references
automatically when inserting a new row. Example: A1=SUM(A4:A8) If I insert a new row on A4 the formula on A1 will now be =SUM(A5:A9) How can I stop it from adjusting automatically, I want A1 should always be =SUM(A4:A8) no matter if I insert a new row. Please help, Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatically adjust charts | Charts and Charting in Excel | |||
| Automatically adjust cells to fit text | Excel Discussion (Misc queries) | |||
| Automatically adjust column widths | Excel Discussion (Misc queries) | |||
| adjust automatically size margins | Excel Discussion (Misc queries) | |||
| Adjust the size of cells automatically | Excel Discussion (Misc queries) | |||
Threaded Mode
