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