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? |
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? |
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? |
All times are GMT +1. The time now is 09:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com