ExcelBanter - How to delete cell values without affecting cell formulae

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to delete cell values without affecting cell formulae (https://www.excelbanter.com/excel-discussion-misc-queries/146830-how-delete-cell-values-without-affecting-cell-formulae.html)

perfection

How to delete cell values without affecting cell formulae

I wish to use a previous years excel sheet but i need to blank out all
entered and caluclated values present. If i do a complete delete i
will lose all the formulae that have vbeen inserted into certain
formulae. How can i delete all values withour the formulae getting
deleted

All times are GMT +1. The time now is 12:02 PM.