Deleting data in cells while saving formatting & formulas

G

greymann19

I have severl large woorkbooks/sheets that I have to reuse each month.
Is there a quick and easy way to remove cell data but keep the cell
formatting and formulas intact? The only way I've figured out so far is
to use the backspace key in every individual cell.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete a formula but leave the data. 2
Editing conditional formats (Excel 2010) 15
Retrieving data from a cell in the last row containing data in the worksheet 1
Excel Formula or VBA Code 2
How to delete ALL cells containing the same data --- REVISED 0
How to delete ALL cells containing the same data 0
"Errored" Cells in Data 0
How to delete ALL cells containing the same data 1

Top