Deleting data in cells while saving formatting & formulas

  • Thread starter Thread starter greymann19
  • Start date Start date
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.
 
You must log in or register to reply here.

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

Excel Excel Vlookup formula based on cell data 7
How to keep formula and be able to input value in cell? 0
Retrieving data from a cell in the last row containing data in the worksheet 1
format cells in one column based on value in another column 3
Excel Drag autofill only part of formula 3
Total cells of one column based on the values in another column? 10
Hiding data in a range of cells 5
Cell Won't Accept Numerical Data 4

Back
Top