MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to make a formula used in multiple cells, take a value for one specific cell only


Posted by Vasileios Gkionakis on October 29, 2001 5:11 PM

Sometimes, for simple simulation problems excel can be quite convenient. However, what I do not know is how to make a formula used in multiple cells to take a value for one specific cell only. What I mean is this:
I have my parameters as well as my variables. I then create the formulas and I copy/paste in order for example to generate an artificial series. However the formula as it is copied and pasted, it is updated by the new values that the variables take as we move down the spreadsheet. But sometimes the formula will contain parameters i.e. values that are to be taken from one specific cell only. Hence my question is how to "lock" this reference cell in the formula so that when I copy and paste it it remains the same i.e. cell B4.
Can anybody help?


Posted by Dan on October 29, 2001 7:28 PM

See the reply to another similar question that should answer your question:
3561.html

Posted by Aladin Akyurek on October 29, 2001 7:28 PM

Activate B4, go the Name Box on the Formula Bar, type a name, and use this name instead of B4 in the formulas that you copy and paste.

Aladin