Insert Row or Column only option

[jimshy]

I can not insert a cell in some worksheets in a Workbook. When I right click in a cell to insert a cell the only option available it to insert a Row or Column. Create a new worksheet in same workbook and the option to insert a cell is available. (get pop up asking where to move the cells to make form - Up, Down, Left of Right.

 

[jimshy]

Happy to send a workbook with the problem -
It's driving me crazy . . . . .

 

[Michael M]

You don't have filters on, do you ??

 

[Fluff]

@jimshy
I removed your email address from your post, as Spam Bots routinely troll Public User Forums like these looking for email addresses to Spam.

Is the cell part of a table?

 

[jimshy]

That was it. Had a filter active - when I cleared all filters - able to insert a cell. Makes perfect sense and obvious why.
My sanity has returned.
Thanks

 

[Michael M]

Easy solve.....'specially when I've been caught with the same thing....