| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 118384 | 2011-06-02 08:00:00 | Excel 2003 help | Happy Harry (321) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 1206329 | 2011-06-02 08:00:00 | Hi Guys I have several spreadsheets (Excel 2003) that I wish to clear the contents but leave the formulas, formats etc intact If I select the cell required to delete then “EDIT”—“CLEAR”—then select “CONTENTS DEL” the formulas get cleared as well. Any thought as to what I suspect I am doing wrong. Google, to date, has not been my friend Cheers HH |
Happy Harry (321) | ||
| 1206330 | 2011-06-02 09:10:00 | www.ehow.com I presume it works. I use calc |
Phil B (648) | ||
| 1206331 | 2011-06-06 01:52:00 | www.ehow.com I presume it works. I use calc Cheers for the answer.That is what I have being trying, but it does clear the formula. I will keep searching. Thanks HH |
Happy Harry (321) | ||
| 1206332 | 2011-06-06 08:23:00 | If you know how to use the F5 Special function this should work Select all your cells on the spread sheet Hit the F5 key ten select the Special button Select the Constants option on the left hand side and hit the ok button - this will select all non-formula cells. You should now be able to hit the delete key and the formulas should remain Trev |
TeejayR (4271) | ||
| 1206333 | 2011-06-06 09:53:00 | This answer (forums.techarena.in) by Chroma seems to support Teejay's suggestion Beats me why they would make a simple operation so difficult to access. |
Phil B (648) | ||
| 1206334 | 2011-06-06 22:41:00 | Thanks Teejay And Phil Yes that does what I was tring to acheive. That process is now logged into my "e-Little Black Book" for further reference. After following the process, and then reading what you are really doing, it does make some sense. Cheers HH |
Happy Harry (321) | ||
| 1 | |||||