Please provide a delete special option which enables users to delete only the formats,values,formula or validation.
Just like the paste special option which enables users to paste the values formula or formats, A delete option for all individual aspects will be really helpful.For example:-If a user just wants to delete a value but not the formula he has to delete the whole thing and retype it again.So this feature can enable them to delete only the aspect they want
This functionality already exists in Excel (but a bit hidden). To take advantage of it, you can:
1. Select the range you want to delete an aspect of
2. On the Home Ribbon > in the Editing chunk (right side of the ribbon) > Clear drop down, choose what it is that you want to clear.
Hope that helps,