locking the result of a formula.

  • Thread starter Thread starter Claire
  • Start date Start date
C

Claire

Is there any way of copying and locking the result gained from a formula so
the result doesnt change when cells used in the formula do??
 
Copy the cell; then use Edit | Paste Special with Values specified in the
dialog box
best wishes
 
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 VBA 1
Formula copying error 3
copying formulas-displaying results 1
Excel not recognizing formula 1
Excel Formula 1
Warning when formula in a cell is changed 3
corrupted formula in protected worksheet 21
Excel 95 (sorry) 7

Back
Top