LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Most efficient method in Excel? Mouse or Keyboard keys? grins Excel Discussion (Misc queries) 15 September 9th 07 07:47 PM
Most efficient formula/combining multiple data cell ranges/seperat Tiff New Users to Excel 1 August 2nd 06 04:56 PM
Excel spreadsheets with data, Powerpoint charts... and VBA! Petitboeuf Excel Discussion (Misc queries) 1 May 26th 06 11:15 AM
Excel Randoming Becoming More Efficient blakrapter Excel Worksheet Functions 6 February 11th 06 12:37 AM
Creating a check box that does not require security clearance. Maverick2U Excel Worksheet Functions 6 December 14th 04 02:46 AM


All times are GMT +1. The time now is 11:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"