Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I freeze formulas in Excel?
I am connecting one worksheet to another, and I want the formulas to remain
constant in the second one--not change relationly as I add information at the top of the first one. |
#2
|
|||
|
|||
Hi Sarah,
Can you provide a little more detail as to what is happening? Thanks, Gary |
#3
|
|||
|
|||
You can remove the formulas and leave the data behind.
Of course, from then on, there's no more calculating going to happen in those cells. Right click in a cell containing one of your formulas and choose "Copy". Right click *again* and choose "Paste Special". Click on "Values", then <OK, then <Esc. And the formula is gone while the data remains! -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Sarah" wrote in message ... I am connecting one worksheet to another, and I want the formulas to remain constant in the second one--not change relationly as I add information at the top of the first one. |
#4
|
|||
|
|||
Anything you put within double quotes will not change when you
insert/delete rows or columns. Use of INDIRECT Worksheet Function. If you gave specific examples of what you have, might have tried to give you a more specific answer. =SUM(INDIRECT("B25:B28")) A formula like =SUM(B25:B28) would change, as would =SUM($B$25:$B$28) when rows/columns are inserted/deleted --- 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 "Ragdyer" wrote in message ... You can remove the formulas and leave the data behind. Of course, from then on, there's no more calculating going to happen in those cells. Right click in a cell containing one of your formulas and choose "Copy". Right click *again* and choose "Paste Special". Click on "Values", then <OK, then <Esc. And the formula is gone while the data remains! -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Sarah" wrote in message ... I am connecting one worksheet to another, and I want the formulas to remain constant in the second one--not change relationly as I add information at the top of the first one. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
Why does Excel 2003 freeze when saving a workbook that has importe | Excel Worksheet Functions | |||
How do I hide formulas in Excel cells? | Excel Discussion (Misc queries) | |||
Excel Formulas | Excel Discussion (Misc queries) | |||
IF/AND formulas within excel | Excel Discussion (Misc queries) |