| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO i ENABLE A COLUMN THAT IS SHADED IN EXEL
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HOW DO i ENABLE A COLUMN THAT IS SHADED IN EXEL
It's probably protected.
Try ToolsProtectionUnprotect Sheet -- Regards, Fred "billy now" <billy wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HOW DO i ENABLE A COLUMN THAT IS SHADED IN EXEL
Brilliant , that solves the problem.
Many thanks Fred, Billy "Fred Smith" wrote: It's probably protected. Try ToolsProtectionUnprotect Sheet -- Regards, Fred "billy now" <billy wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HOW DO i ENABLE A COLUMN THAT IS SHADED IN EXEL
Glad it worked. Thanks for the feedback.
-- Regards, Fred "billy now" wrote in message ... Brilliant , that solves the problem. Many thanks Fred, Billy "Fred Smith" wrote: It's probably protected. Try ToolsProtectionUnprotect Sheet -- Regards, Fred "billy now" <billy wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shaded cells won't print shaded | Excel Worksheet Functions | |||
| How can I find duplicates in one column of an exel spreadsheet? | Excel Worksheet Functions | |||
| how to hyperlink entire column in Exel sheet | Excel Discussion (Misc queries) | |||
| add a row or column to a single cell in exel | Excel Discussion (Misc queries) | |||
| Anyway to set numerical column name as Exel convention? | Excel Worksheet Functions | |||
Linear Mode
