Converting formulas to values is a great way to freeze your data, reduce file size, and prevent accidental changes to calculated results.
Mit KI erledigenDie Zellen auswählen
Highlight the range of cells containing the formulas you want to convert.
Copy the selection
Press Ctrl + C (or Cmd + C on Mac) to copy the selected cells to your clipboard.
Use Paste Special
Right-click on the same selection, go to 'Paste Special', and select the 'Values' icon (represented by 123).
Yes, you can press Ctrl + Z immediately after pasting to revert the cells back to their original formulas.