| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent auto incrementation of formula
Does anyone know of a way to prevent formula from automatically updating
themselves when new cells are added into a range. I'm trying to base a calculation on the first 20 cells in a range of cells, additional cells will be inserted at the start of this range, but I don't want the formula to update the range past the first 20 cells. (I'm getting an average of the 20 latest figures to be entered, if that helps). Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to prevent auto scaling of header and footer when printing | Excel Discussion (Misc queries) | |||
| How to prevent the auto resizing of a column (ie, lock the width) | Excel Discussion (Misc queries) | |||
| Scroller Incrementation | Charts and Charting in Excel | |||
| How do I prevent Excel from auto-correcting the date format? | Excel Discussion (Misc queries) | |||
| prevent auto convert format | Excel Discussion (Misc queries) | |||
Threaded Mode
