HOW DO i ENABLE A COLUMN THAT IS SHADED IN EXEL

[Guest]

I have received a mortgage table which calculates on a mortgage of 200000
over 20 years . the columns showing interest principal and scheduled
payments are blocked. how di i unblock these columns so that i can enter
variable data eg
what would the interest principal and scheduled repayments be on 100000
after year 12 etc.
Thanks
Billy now

 

[Fred Smith]

It's probably protected.

Try Tools>Protection>Unprotect Sheet

 

[Guest]

Brilliant , that solves the problem.
Many thanks Fred,
Billy

 

[Fred Smith]

Glad it worked. Thanks for the feedback.