| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I insert a row without the formula changing?
You can use OFFSET from $A$1
or you could write your formula so that the address is within double quotes. If that does not help or get you started, ... What is the formula(s) that is not change. Examples of what you want, what you tried, and what you got are always helpful. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "BertiesMum" wrote in message ... I have set up a work book to calculatre 12 week averages, and need to insert a new row each week, but when I do the formulas change. How do I stop this to make the formula take account of the new row? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing what is displayed in the formula bar | Excel Discussion (Misc queries) | |||
| Keep formula from changing? | Excel Worksheet Functions | |||
| Insert New Row without shifting formula | Excel Worksheet Functions | |||
| Preform alphabetical sort without formula in cell changing | Excel Discussion (Misc queries) | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
Threaded Mode
