Thread: Template
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Template

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)



Dee wrote:

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