You say that some cells work OK.

Copy those that do work to those that do not and I think that you will then
be able to do the formatting that you require.

Please hit yes if my comments have helped.

Thanks.

"dawall33" wrote:

I have a xls file that will not let me do any cell formatting to some cells.
I can use the format painter to force changes. The sheet is not protected.
I have the same problem whether it is marked locked or not.

When I select Format | Format Cells.. , right click the cell and select
"Format Cells..", CTRL+1, nothing happens. I can use the Alignment buttons
but will never get the Format Cells Dialog Box.

Other cells on the same sheet work just fine? I'm using 2007