How to fix the function value in Google Spreadsheet?

How we can fix the result of the function in Google spreadsheets? For example, I have entered

=2*A1; 

for B1 and what should I do to keep B1 fixed so that it won't be affected by the changes in A1.

The question can b开发者_如何学JAVAe awkward, but I couldn't have found a way to do it.

You can do it by replacing formula with its result:

1. Select cells, which you want to keep value only
2. Dropdown toolbar Edit, choose Copy
3. Dropdown toolbar Edit, choose Paste value only

I hope it's that what you mean

I think this might be the link you are looking for.

Simply write a "$" before the cell or column or whatever you wanna have to fixed.

Example: $D$4 if you write $D4 you will only get column fixed what I understand.

http://www.gcflearnfree.org/googlespreadsheets/14.3

The point of functions is so that B1 IS affected by A1. If you don't want a relationship there, don't use a function. As far as I know, you will need to just manually type in the value you want, or copy the cell, and right click the cell and click "Paste values only."