Susan
This can also apply to cells in columns as well

MM

"susanholland3" wrote:

I don't have any merged cells, at least not that I know of or that I
intended. I have created lists from this worksheet and wonder if it thinks I
still have a list open, but don't know how to correct for that.

I tried locating the row above and below where I need it----it didn't work.
Thanks for trying.

"Michael M" wrote:

Hi Susan
It sounds like the location your are trying to insert a row has merged cells
in it.
You will need to either unmerge the cells or go 1 row above or below the
merged area.

HTH
Michael

"susanholland3" wrote:

I am trying to insert a row of simple data into my worksheet. When I do, I
get the following message:

"This operation is not allowed. The operation is attempting to shift cells
in a list on your worksheet."

I don't understand this. I have created lists from the worksheet but don't
have any now. Why does it think I have a list on my worksheet? And, if I have
one, how do I remove it?

I couldn't find anything on this in the knowledge base and am very
frustrated. Thanks for any help.