| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do I delete data from a worksheet without deleting the formul.
I am trying to clear just the data from a large sheet, and I want to keep the
formulas. This has to be possible, right? |
|
#2
|
|||
|
|||
|
Jack
Select all cells with CTRL + A(twice in 2003) OR possibly you don't want to touch titles so select just the range to clear. F5SpecialConstants. Check or uncheck what you want to find/keep and OK. EditClearContents. Gord Dibben Excel MVP On Wed, 16 Feb 2005 16:41:03 -0800, "Jack" wrote: I am trying to clear just the data from a large sheet, and I want to keep the formulas. This has to be possible, right? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| URGENT Please... new worksheet with copied formats but no data. | Excel Worksheet Functions | |||
| Reference Data in Moved Worksheet | Setting up and Configuration of Excel | |||
| Automatically pull data into another worksheet within the same fil | Excel Worksheet Functions | |||
Linear Mode
