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

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

The only time I've seen this is when the original workbook was created in a
different program--crystal reports or Lotus 123.

I included a few "sacrificial" cells in my selection, made my changes to all of
them.

Then went back and fixed the sacrificial cells to the way they were supposed to
be. (I included a cell way out of the way of where the data really is.)

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

--

Dave Peterson

Can I park the data that is in the cells that I'm having problems with?

"trip_to_tokyo" wrote:

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