I don't know why or how this happens, but I was able to fix it without
re-creating the worksheet. Highlight the worksheet area and paste into a new
workbook. Co not copy the worksheet using the "move / copy" command from
right-clicking the sheet tab name. It will not work. Good Luck

"Mamarapha " wrote:

Some cells in my worksheets won't allow any formatting, even though they
are not locked, the sheet & workbook are not protected or shared. I can
copy other formatted cells into them, but cannot change the formatting.
Any ideas?


---
Message posted from http://www.ExcelForum.com/

I am having the same problem as Mamarapha. I have tried your solution but it
causes Excel to crash everytime. Any other suggestions?

"Grapefrog" wrote:

I don't know why or how this happens, but I was able to fix it without
re-creating the worksheet. Highlight the worksheet area and paste into a new
workbook. Co not copy the worksheet using the "move / copy" command from
right-clicking the sheet tab name. It will not work. Good Luck

"Mamarapha " wrote:

Some cells in my worksheets won't allow any formatting, even though they
are not locked, the sheet & workbook are not protected or shared. I can
copy other formatted cells into them, but cannot change the formatting.
Any ideas?


---
Message posted from http://www.ExcelForum.com/