Format cells unavailable

G

George Wilson

I am assisting a customer running Word 2000 on a Windows
2000 system. He has a spread sheet that will not allow him
to do a format > cells on the header row and a few rows
below. We can select the colum and this option works but
nothing happens when using this option for an individual
cell. I don't think these items are protected, is there
any way I can be sure? I tried selecting all of the
columns and unlocked the cells and this did not help. Can
anyone think of any reason why format cells would not be
available on this sheet?
TIA
George
 
D

Doug Kanter

Tools, Protection. If the sheet's protected, you'll see "Unprotect sheet",
and vice versa.
 
G

George Wilson

Thank you for your response. OK, did that, it says protect
sheet, so its not protected. What else could cause this?
TIA
George
 
D

Dave Peterson

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.
 
Top