How to Clear All Formulas in Excel

Buzz

Content

1. Delete Excel formulas while keeping results

Your Excel file contains numerous formulas and you want to clear all formulas in Excel because your current work only requires obtaining result values? Unsure how to do it? Check out this trick to help you easily and quickly clear all formulas in Excel in the article below.

In Excel, using functions aids in calculating and processing data. If you want to clear all formulas in Excel to retrieve the result value of that formula, or because those formulas are incorrect due to improper use of calculation functions, you can achieve this by clearing all formulas while keeping the result values unchanged, or by clearing both the formulas and result values.

Trick to Clear Formulas in Excel

How to Clear All Formulas in Excel

* Preparation Steps:

- Ensure your computer is equipped with commonly used Excel programs such as: Excel 2013, Excel 2016.

- Have an Excel file containing multiple formulas ready for removal.

1. Delete Excel formulas while keeping results

Step 1: You select all data tables in Excel that you want to remove formulas from, or you can press the Ctrl + A key combination.

Step 2: Next, you right-click and choose Copy to copy the table.

Step 3: Then, you right-click again, in the Paste Options section, choose the Values icon (V).

If you're working on a report and want to share this Excel report with others without revealing the formulas used for calculations, consider hiding the formula cells in Excel, as previously instructed and shared by Mytour. Wishing you success!

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]