Displaying a cell's value versus it's formula

  • Thread starter Thread starter Kris
  • Start date Start date
K

Kris

I have created an amortization schedule. When you click on
a cell the toolbar shows the formula I used instead of the
dollar value. I don't want anyone to know the formula I
used so I want only the value show in the cell. I know you
can click on a cell and F2 and then F9 to calculate the
value, but I don't want to do that to calculate each
individual cell. Is there a faster way to do the whole
schedule at once? Thank you, Kris
 
If you lock your cell, and protect the workbook, you can hide the formulas and
just see the results.

Select your range to lock
Format|cells|Protection tab
Check locked

But you have to protect the worksheet, too.
tools|Protection|protect sheet

That said, worksheet protection is very weak. There's code posted here every
day/week that would unprotect the worksheet.
 
Kris

You can change all at once to values if you wish, rather than F2/F9

Copy the cells then(in place)Paste Special>Values>OK>Esc

Gord Dibben Excel MVP
 
Back
Top