Efficient data clearance in Excel spreadsheets
 

An old mainframe based spreadsheet program called Foresight had a function
called "Clear all" which cleared all input values or constants from an entire
spreadsheet without affecting any cells containing formulas, functions, etc.
This allowed for quick, safe resetting of pro-forma type spreadsheets.
Is there a way to accomplish this in Excel? If not there should be.

Efficient data clearance in Excel spreadsheets
 

joatmon

Goto: EditGo ToSpecialConstantsOK. This will select all constrants and
all you need to do is tap delete.

Mike Rogers

"joatmon" wrote:

An old mainframe based spreadsheet program called Foresight had a function
called "Clear all" which cleared all input values or constants from an entire
spreadsheet without affecting any cells containing formulas, functions, etc.
This allowed for quick, safe resetting of pro-forma type spreadsheets.
Is there a way to accomplish this in Excel? If not there should be.

Efficient data clearance in Excel spreadsheets
 

Thanks for that Mike. I didn't know that was there! It's a useful little
tool for identifying types of information in cells.

Bill Ridgeway

"Mike Rogers" <Mike060349@NoxSpamxAOLDOTcom wrote in message
...
joatmon

Goto: EditGo ToSpecialConstantsOK. This will select all constrants
and
all you need to do is tap delete.

Mike Rogers

"joatmon" wrote:

An old mainframe based spreadsheet program called Foresight had a
function
called "Clear all" which cleared all input values or constants from an
entire
spreadsheet without affecting any cells containing formulas, functions,
etc.
This allowed for quick, safe resetting of pro-forma type spreadsheets.
Is there a way to accomplish this in Excel? If not there should be.

Efficient data clearance in Excel spreadsheets
 

Bill Ridgeway

Just one of the many thing I learned right here!!!!

Thanks goes to all others!!!

Mike Rogers

"Bill Ridgeway" wrote:

Thanks for that Mike. I didn't know that was there! It's a useful little
tool for identifying types of information in cells.

Bill Ridgeway

"Mike Rogers" <Mike060349@NoxSpamxAOLDOTcom wrote in message
...
joatmon

Goto: EditGo ToSpecialConstantsOK. This will select all constrants
and
all you need to do is tap delete.

Mike Rogers

"joatmon" wrote:

An old mainframe based spreadsheet program called Foresight had a
function
called "Clear all" which cleared all input values or constants from an
entire
spreadsheet without affecting any cells containing formulas, functions,
etc.
This allowed for quick, safe resetting of pro-forma type spreadsheets.
Is there a way to accomplish this in Excel? If not there should be.