View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
joatmon joatmon is offline
external usenet poster
 
Posts: 1
Default 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.