Cannot format cells

  • Thread starter Thread starter FK
  • Start date Start date
F

FK

I have a spreadsheet that will not allow me to format
most of the cells. If I right click on any cell or range
of cells and pick Format Cells nothing happens. The
dialog box does not open.

I can format some of the cells on the sheet but there is
no rhyme or reason to it.

There are some borders of differing types and this seems
to be the problem as I can copy the spreadsheet to a new
page, delete all the borders and then re-do them
identically to the original and then the Format Cells
dialog box works.

I can copy a format from one cell to another and that
works too.

There are no merged cells, the data has not been
imported from Access, the cells are not locked and there
is no protection.

Any ideas?
 
sounds like the worksheet has protection turned on. Some
cells can individually be turned off so they can be edited.

Under Tools menu, choose protection, see if ticked.

Individual cells, under Format, cells, protection tab.
 
No. There is no protection turned on.

-----Original Message-----
sounds like the worksheet has protection turned on. Some
cells can individually be turned off so they can be edited.

Under Tools menu, choose protection, see if ticked.

Individual cells, under Format, cells, protection tab.


.
Click to expand...
 
Back
Top