How to Delete Microsoft Excel Values, Keep Formulas

Introduction

In Microsoft Excel, you can create a worksheet that will be used to input numbers, with formulas set to perform calculations on those input numbers (known as values). You can use the worksheet repeatedly by clearing the values while retaining the formulas. For instance, you might create a monthly budget where you can save the current month’s budget with next month’s name, then delete this month’s data leaving the formulas for next month’s budget. This tip tells you how to quickly delete those values while retaining the formulas.