| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I clear contents from a spreadsheet but not the formulas
I want to use my 2006 spreadsheet in 2007 using the same formulas, but
different data. How do I erase last years data "en mass", but leave the formulas in place. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I clear contents from a spreadsheet but not the formulas
Edit--Goto--Special--Constants
Hit delete. Of course try this with a backup copy to make sure it's deleting only what you think it should be! Dave -- Brevity is the soul of wit. "Roberto" wrote: I want to use my 2006 spreadsheet in 2007 using the same formulas, but different data. How do I erase last years data "en mass", but leave the formulas in place. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| spreadsheet contents have become hidden from view | Excel Discussion (Misc queries) | |||
| Why is my spreadsheet not updating changed formulas? | Excel Discussion (Misc queries) | |||
| what is the maximum no of formula's in 1 spreadsheet? | Excel Worksheet Functions | |||
| paste contents from other spreadsheet | Excel Worksheet Functions | |||
| Copying options: contents, results, formulas, etc. | New Users to Excel | |||
Linear Mode
