Ask Your Question

Reset a Spreadsheet - Delete your data but not your formulas

asked 2019-12-06 16:01:56 +0100

obzolete gravatar image


I have looked everywhere for an answer for the above I have only started using Calc and I have a spreadsheet I was testing with various scenarios but realise when i delete a figure it deletes the formula. Can I get back to a clean sheet inc my formulas?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-12-06 16:46:32 +0100

erAck gravatar image

updated 2019-12-06 16:47:19 +0100

Select/mark the cell range, hit Backspace key (or menu Sheet -> Clear Cells...), uncheck Formulas, OK

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-12-06 16:01:56 +0100

Seen: 272 times

Last updated: Dec 06 '19