formating of certain cells not possible!

G

Guest

Office XP
We have aspreadsheet and we just noticed that some of the horizontal
gridlines in certain cells through out the sheet are grayed out. No Fill. If
we right click on the those cells and then click on "format Cells" (which BTW
is NOT grayed out) -nothing. The format box doesnt not appear!! Also the
margin box is NOT grayed out yet it has no affect on the cell. In further
checking we noticed that this problem is not limited to the grid lines. In
cells with text or numbers we can enter data, etc. but be can not apply any
cell formatting to them. If we scroll around we can find cells that are
formatable in the normal fashion. There is no links, protection, white
cells,etc. Any ideas????
 
G

Guest

Marty said:
Office XP
We have aspreadsheet and we just noticed that some of the horizontal
gridlines in certain cells through out the sheet are grayed out. No Fill. If
we right click on the those cells and then click on "format Cells" (which BTW
is NOT grayed out) -nothing. The format box doesnt not appear!! Also the
margin box is NOT grayed out yet it has no affect on the cell. In further
checking we noticed that this problem is not limited to the grid lines. In
cells with text or numbers we can enter data, etc. but be can not apply any
cell formatting to them. If we scroll around we can find cells that are
formatable in the normal fashion. There is no links, protection, white
cells,etc. Any ideas????
I just found that this "problem" is confined to cols "B" to "L". Is it
possible to :prevent formating changes to spefic cols?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top