Deleting the DATA but NOT the Formulae!

  • Thread starter Thread starter Big Gray Cat
  • Start date Start date
B

Big Gray Cat

Folks ---
I have a spreadsheet that got -- to understate the matter, delicately -- the
wrong
data pasted into it. I need to delete JUST the numbers, but leave the
recalculation
logic in place. How does one do this?

Thankx in advance from the Big Gray Cat.
 
Press F5
Click on Special
Check the Constants option
Click Ok
Press Delete
 
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 Charts 3
Protecting cell formulas in excel 2007 1
Formula to copy cell data 5
Refreshing formulas automatically 3
Access Data Entry Forms --- 1
Excel 2007 - Recalc or NOT 2
Static date formula 3
Formula Problem 1

Back
Top