Template

[Dee]

I have created a working home budget and would now like to turn it into a
template for future years. How can I delete the values in the cells without
losing the formulas and formating?

 

[Dave Peterson]

You have cells that are simply labels (headers, descriptions and
instructions???).

You have cells that are used for getting input from the user.

You have cells that contain formulas.

You'll want to select the cells that are used for input and then hit the delete
key on the keyboard to clear them.

You may want to change some of your formulas so that the cells with the formulas
look empty if the input cell is empty:

For instance, if A1 was the input cell, you could use:

=if(a1="","",someformulathatdependsonthevalueinA1)