I am trying to save last years workbook, that accumulates data and totals
numbers. I need to erase last years inputed data, but want to keep the
formulaes intact. If I delete the data, it deletes the formulaes, if i clear
contents it does the same to the formulaes. I don't want to re-input the
same formulaes for every month in the year data base.

Hi,

Test this on a non-critical workbook

tap F5
Click 'Special'
Select 'Constants'
Un-check 'Text' and 'Logicals'
OK
Tap delete

Mike


"denvancam" wrote:

I am trying to save last years workbook, that accumulates data and totals
numbers. I need to erase last years inputed data, but want to keep the
formulaes intact. If I delete the data, it deletes the formulaes, if i clear
contents it does the same to the formulaes. I don't want to re-input the
same formulaes for every month in the year data base.

hi
hit the F5 key. this will bring up the goto dialog. click the special key on
the dialog.
select constrants, click ok
this should select all non-formula data.
hit the delete key. data gone, formulas still there but with no data to
calculate, they should all read zero.
as always it's a good idea to save a backup copy prior, just in case.

Regards
FSt1

"denvancam" wrote:

I am trying to save last years workbook, that accumulates data and totals
numbers. I need to erase last years inputed data, but want to keep the
formulaes intact. If I delete the data, it deletes the formulaes, if i clear
contents it does the same to the formulaes. I don't want to re-input the
same formulaes for every month in the year data base.

Just to add to the other responses you have...

I bet that there are cells with values/constants that you want to keep--like
headers and descriptions.

So before you use the suggested techniques, select the range that you want to
clear first. It can include formulas (those will be eliminated with the special
cells stuff), but don't include any of the constants you want to keep.



denvancam wrote:

I am trying to save last years workbook, that accumulates data and totals
numbers. I need to erase last years inputed data, but want to keep the
formulaes intact. If I delete the data, it deletes the formulaes, if i clear
contents it does the same to the formulaes. I don't want to re-input the
same formulaes for every month in the year data base.

--

Dave Peterson

What is the Mac equivalent to this?

Thanks

On Friday, December 05, 2008 5:56 PM denvanca wrote:

I am trying to save last years workbook, that accumulates data and totals
numbers. I need to erase last years inputed data, but want to keep the
formulaes intact. If I delete the data, it deletes the formulaes, if i clear
contents it does the same to the formulaes. I don't want to re-input the
same formulaes for every month in the year data base.


On Friday, December 05, 2008 6:07 PM Mike wrote:

Hi,

Test this on a non-critical workbook

tap F5
Click 'Special'
Select 'Constants'
Un-check 'Text' and 'Logicals'
OK
Tap delete

Mike


"denvancam" wrote:


On Friday, December 05, 2008 6:15 PM FSt wrote:

hi
hit the F5 key. this will bring up the goto dialog. click the special key on
the dialog.
select constrants, click ok
this should select all non-formula data.
hit the delete key. data gone, formulas still there but with no data to
calculate, they should all read zero.
as always it's a good idea to save a backup copy prior, just in case.

Regards
FSt1

"denvancam" wrote:


On Friday, December 05, 2008 8:15 PM Dave Peterson wrote:

Just to add to the other responses you have...

I bet that there are cells with values/constants that you want to keep--like
headers and descriptions.

So before you use the suggested techniques, select the range that you want to
clear first. It can include formulas (those will be eliminated with the special
cells stuff), but don't include any of the constants you want to keep.



denvancam wrote:

--

Dave Peterson