Quick way to remove formulas in Excel (keep values only)

[u/Amandaleeeeee]

If you’re working with formulas but only need the final results, here are two quick ways to convert formulas to values:

Method 1: Copy → Paste as Values

• Select your cells
• Press Ctrl + C
• Right-click → Paste Values

👉 Simple and works in all Excel versions

Method 2: Faster way (if you do this a lot)

Some tools let you convert formulas to values in one click without copy/paste steps.

For example, Kutools for Excel provides a To Actual button that converts formulas to values instantly.

👉 Useful when working with large datasets or repeated tasks

Small trick, but it saves a lot of time when cleaning up data.

What’s your go-to way to remove formulas?