I can delete data, but it delets the formula. Is there any way to lock a
formula, but can still clear data?
Thanks
I can delete data, but it delets the formula. Is there any way to lock a
formula, but can still clear data?
Thanks
Dave
Two ways
1) If it's just for you go to Edit>Go to>Special... and select 'Constants'
and/or numbers and text and pres the delete key
2) For all users, select all the cells you want to delete. (You might do
this by method 1) and then go to Format>Cells>Protection and un-check
locked. Now go to Tools>Protection>Protect sheet... and you will now only be
able to delete the cells you want deleted.
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]HIS
"Dave" <[email protected]> wrote in message
news:[email protected]...
>I can delete data, but it delets the formula. Is there any way to lock a
> formula, but can still clear data?
>
> Thanks
Dave
Edit>Go To(or F5)>Special>Constants. Tickmark what you want selected then OK
your way out.
Edit>Delete what is highlighted.
Gord Dibben Excel MVP
On Sat, 1 Jan 2005 20:15:03 -0800, "Dave" <[email protected]>
wrote:
>I can delete data, but it delets the formula. Is there any way to lock a
>formula, but can still clear data?
>
>Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks