Loading suggested videos
Ctrl + A
to select the entire sheet.Ctrl + C
to copy the selected content.Ctrl + Alt + V
to open the Paste Special
dialog box.Values
and click OK
.Result: All formulas will be replaced with their calculated values — the cells will no longer contain any formulas.
Tip: This method is useful when sharing data without revealing your underlying calculations.
Your feedback helps us improve our content.