Displaying a cell's value versus it's formula

[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

 

[Dave Peterson]

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.

 

[Gord Dibben]

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