Insert cell problem

[Dave]

On one worksheet, attempts to insert a cell are thwarted--only insert
row or column is allowed--other options are grayed out.

I've tried cells across the ENTIRE worksheet, and they all exhibit the
same behavior. However, it DOES work normally if I copy and paste part
of it into a new sheet.

Is there some setting that can affect an entire sheet? There are no
merged cells, or hidden rows or columns.

(Yes, I am sure I am not selecting more than one cell!)

 

[David McRitchie]

Hi Dave,
I expect you have Sheet protection turned on, but can't
see how you would get some of the insert options.