some cells show shape format and will not allow me to edit the cell normally. how do I disable shape format for cells?
There is a shortcut for hiding All Floating shapes in the worksheet (Shapes, Charts, Pictures...) so if you hide them you will be able to format the cell underneath. The shortcut is CTRL +6
By the way, it's a toggle shortcut.
Hope that helps