![]() |
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? |
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? |
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