Clear values but keep formulas?

  • Thread starter Thread starter Gumby
  • Start date Start date
G

Gumby

I have created a work sheet where now I would like to delete all the values
but keep all the formulas. Can this be done?
 
hi
try this
press F5 to get the goto dialog.
click the special button at the botton
select contrants>ok
you have select all non-formula cells.
hit the delete key
you may get a few #DIV/0! errors

Regards
FSt1
 
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 Help to copy information from one row at a time to another sheet 1
Paste contents, but keep formula of destination 2
How to keep formula and be able to input value in cell? 0
Special Pasting a work book with many sheets and formulas 2
Excel Excel Vlookup formula based on cell data 7
EMBED VLOOKUP AND SIMPLE IF FORMULA IN A WORKBOOK 13
Need help with macro to copy, paste, and clear cell values 8
Copy Excel sheets 1

Back
Top