ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Delete contents deletes all data and formulas (https://www.excelbanter.com/excel-discussion-misc-queries/263995-delete-contents-deletes-all-data-formulas.html)

tdhcrr

Delete contents deletes all data and formulas
 
When I hit delete contents all data and formulas are deleted. How can I
delete data without deleting formulas?

Mike H

Delete contents deletes all data and formulas
 
Hi,

You could try this

tap F5 - Special - Constants - OK

and if that selects the data you want to delete then tap the delete key
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"tdhcrr" wrote:

When I hit delete contents all data and formulas are deleted. How can I
delete data without deleting formulas?


Bob I

Delete contents deletes all data and formulas
 
First use Find and Select, Constants, THEN Clear Contents

tdhcrr wrote:

When I hit delete contents all data and formulas are deleted. How can I
delete data without deleting formulas?




All times are GMT +1. The time now is 02:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com