PDA

View Full Version : Excel 2003 help



Happy Harry
02-06-2011, 08:00 PM
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

Phil B
02-06-2011, 09:10 PM
http://www.ehow.com/how_5955301_delete-data-excel-not-formulas.html

I presume it works. I use calc

Happy Harry
06-06-2011, 01:52 PM
http://www.ehow.com/how_5955301_delete-data-excel-not-formulas.html

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

TeejayR
06-06-2011, 08:23 PM
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

Phil B
06-06-2011, 09:53 PM
This answer (http://forums.techarena.in/windows-software/1192348.htm) by Chroma seems to support Teejay's suggestion
Beats me why they would make a simple operation so difficult to access.

Happy Harry
07-06-2011, 10:41 AM
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