| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Hi
1. Select one cell on the relevant worksheet. 2. Press F5 and select "Special" 3. Select "Constants" from the dialog box. 4. Select "OK" 5. Hit the "Delete" button on your keyboard. -- ----- XL2003 Regards William " . com wrote in message ... When I choose the option to clear, my formulas are deleted too. Is there a way to delete values only? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
| Adding values from one worksheet to another | Excel Worksheet Functions | |||
| Need ability to leave certain cells of an worksheet editable. | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
| how to extract only values from an Excel worksheet? | Excel Worksheet Functions | |||
Threaded Mode
