Loan amortisation Template

D

Dhananjay

Hi,
I opened a loan amortization template in this i can able to enter only date
in particularcells and some ranges are freezed so that the cells are not able
to activate at all . I am preparing some workings so i want to give like this
conditions to my users how to freeze or Lock to unactivate cells and freeze
in work sheet
 
B

Brad Vogt

There is no password to unlock the worksheet. Just go to the review tab and
click on unprotect sheet in the changes group. You will then be able to
select and change any cell. Note however that you are also able to damage
the formulas and functions in the sheet, so you must be careful.
 

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

Top