Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Locked out of Cell Formatting
In Excel 2003 I (& some other users in the office) am sometimes locked out of
the Formatting options; nothing I try will open the Format Cells dialog: the menu command Format, Cells does not work; the Button on the Toolbar does not work; Ctrl+1 does not work. In the worksheet I am currently working on, I can open the options if I select the entire worksheet, but selecting rows or cells will not work. Any ideas? -- - markvi |
#2
|
|||
|
|||
Tools, Protection, Protect sheet will cause this (except for the "if I
select the entire worksheet" part). -- Jim "markvi" wrote in message ... | In Excel 2003 I (& some other users in the office) am sometimes locked out of | the Formatting options; nothing I try will open the Format Cells dialog: the | menu command Format, Cells does not work; the Button on the Toolbar does not | work; Ctrl+1 does not work. In the worksheet I am currently working on, I can | open the options if I select the entire worksheet, but selecting rows or | cells will not work. Any ideas? | -- | - markvi |
#3
|
|||
|
|||
Thanks. A good idea, but it didn't help. I selected the whole sheet & turned
off "Locked". I can click certain cells in the worksheet and then go right into Format; other cells (the ones I need to change, of course) - nothing happens. -- - markvi "Jim Rech" wrote: Tools, Protection, Protect sheet will cause this (except for the "if I select the entire worksheet" part). -- Jim "markvi" wrote in message ... | In Excel 2003 I (& some other users in the office) am sometimes locked out of | the Formatting options; nothing I try will open the Format Cells dialog: the | menu command Format, Cells does not work; the Button on the Toolbar does not | work; Ctrl+1 does not work. In the worksheet I am currently working on, I can | open the options if I select the entire worksheet, but selecting rows or | cells will not work. Any ideas? | -- | - markvi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting a full row triggered by a single cell reference... | Excel Worksheet Functions | |||
retrieve cell formatting with IF(HLOOKUP) formula | Excel Worksheet Functions | |||
cell formatting problems | New Users to Excel | |||
How can I get a cell locked if the condition is false? | Excel Worksheet Functions | |||
Formatting dates in the future | Excel Worksheet Functions |