Use Paste Values when you want a fixed result rather than a calculation that keeps updating. Normal paste can copy the formula and adjust its relative references. Replacing formulas also removes their logic, so make a separate workbook copy before changing an important range.
See the difference on two cells
On an empty test sheet, enter 7 in A2 and =A2*2 in B2. B2 displays 14. Copy B2, select D2 and choose Home, Paste, Values. Select D2 and inspect the formula bar: it should contain 14 without a leading equals sign. Then change A2 to 8. B2 should become 16 while D2 stays 14.
Use this small worksheet to check the behaviour before working on the real range. Copying the formula normally to D2 would move its relative reference to C2, which may produce a different result.
Keep the number’s meaning
Values alone do not carry the original number format. A date can appear as its serial number, and a percentage can lose its familiar display. Where needed, choose Values and Number Formats, or apply the destination format deliberately. Check a date, a percentage and a total before processing a large selection. Menu labels vary with language and client; Microsoft documents Paste Values for Windows and the web.
Preserve the calculation version
Save the fixed-results copy under a different name. Reopen it and inspect the intended range, including a cell that originally referred to another workbook. Converting selected cells is not a full audit of other sheets or links. Keep the original formulas when you will need to recalculate later.