Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I clear a worksheet of values, but leave formulas intact?
When I choose the option to clear, my formulas are deleted too. Is there a
way to delete values only? |
#2
|
|||
|
|||
Hi
choose edit / goto and click on the special button choose constants (there's some tick boxes you can play with too) and then click ok now only the "values" will be selected in your worksheet now press your delete key PS always try something like this on a copy of your workbook, just in case it doesn't work as planned -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway " . com wrote in message ... When I choose the option to clear, my formulas are deleted too. Is there a way to delete values only? |
#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? |
Reply |
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 |