Tip of the week # 42026 April 2014

Find and delete all data but keep formulas (Microsoft Excel)

Have you ever had the need to keep your formulas in a worksheet, but get rid
of all the other data? For example, you might want to create a new sheet for
the new tax year, containing exactly the same headers and formulas, but not
the data from the previous tax year.

Here's how:

Select the rows and/or columns that contain the formulas. (Remember the
quick way to select a range of cells? See tip_306.php)

On the Home tab, in the Editing group, click Find & Select, and
then click Go To Special. (Or press CTRL + G and click on the
Special button.)

In the Go To Special dialog box, click the Constants radio button.

Click OK.

Press the Delete key on your keyboard.

This will delete all the data, but leaves the formulas, ready for next
year's tax year. (Thanks for the inspiration, Melissa.)