A copied spreadsheet cell can carry a formula or only the result that formula currently displays. The difference becomes visible when the source changes. A three-cell exercise is enough to test it before working on an important file.
Build a result you can change
- In a practice sheet, enter 3 in A1 and 4 in B1.
- Put
=A1*B1in C1. It displays 12. - Copy C1 and use Paste Special, or your application’s equivalent option, to paste only values into another cell.
The Google Sheets copy-and-paste guide provides one application-specific reference for these options.
Now change A1 to 5. C1 should recalculate to 20; the pasted value remains 12. It is a snapshot of the earlier result, not a second live calculation. Check the formula bar to verify what is stored rather than judging only by the number visible in the grid.
Decide whether the connection should survive
Values-only pasting can be useful for a dated result that must stay fixed. It can also silently break a worksheet that was supposed to update. Write down the purpose before choosing the option.
If you copy a formula instead, references may adjust according to their relative or absolute form and the destination. Test that separately; do not mix two unfamiliar operations into one experiment. Keep the original working file until the result has been checked. A successful paste means the destination contains the intended kind of information, not merely that it looks identical for a moment.
AI-generated editorial illustration; not a documentary photograph.