How to fix the function value in Google Spreadsheet?

Question

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 be awkward, but I couldn't have found a way to do it.

Answer 1

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