| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
remove the cells contents (data) without removing formulas Excel 2
I need to remove all the data in a woorksheet whithout removing the formulas
in Exel 2007. I want to use the woorksheet for a new year |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
remove the cells contents (data) without removing formulas Excel 2
Press F5
Click on Special Choose CONSTANTS Click OK Press Delete... "onebigred51" wrote: I need to remove all the data in a woorksheet whithout removing the formulas in Exel 2007. I want to use the woorksheet for a new year |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
remove the cells contents (data) without removing formulas Excel 2
You may want to preserve titles text as well.
Uncheck the option "Text" Gord Dibben MS Excel MVP On Tue, 17 Mar 2009 08:30:22 -0700, Sheeloo just remove all As... wrote: Press F5 Click on Special Choose CONSTANTS Click OK Press Delete... "onebigred51" wrote: I need to remove all the data in a woorksheet whithout removing the formulas in Exel 2007. I want to use the woorksheet for a new year |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I shift the contents of the cells up to remove empty cells. | Excel Discussion (Misc queries) | |||
| Removing data entries but not formulas or formats | Excel Worksheet Functions | |||
| remove figures from a cell without removing the formulas | Excel Worksheet Functions | |||
| Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) | |||
| Pasting data without removing formulas | Excel Discussion (Misc queries) | |||
Linear Mode
