Thanks for your response, Dave. I also questioned the validity of shifting
cells down. Actually that is exactly what my OP wants to do, following copy
some data in from another spreadsheet.

I first thought the problem was related to the fact that autofilter was on
and that some columns were hidden. OP showed me examples of previous
spreapsheets where both situations were involved and Insert Cells did work.
I tested a different set of workbopoks on my machine and sure enough, the
InsertCells was available.

We never found a way to FIX the problem with that workbook. The OP rebuilt
the offending workbook

OP did report one difference in procedure for the problem workbook. They had
deleted rows WHILE the filter was invoked. WE suspect that this might have
been the cause of the problem. Does that scenario seem plausible?

Thanks for your time and expertise. The support you and other contributors
to this forum provide certainly make life more bearable for the rest of us.



"Dave Peterson" wrote:

I think your data is filtered--some rows are hidden.

Data|Filter|show all
and then you can insert cells and shift cells down or right.

But are you positive that you want to shift the cells down. Without any
knowledge of what your table contains, I would think that you'd always want to
keep the data on any row on the same row.

JR Hester wrote:

One of my users has a handed me a unique problem, that I can't duplicate in
otehr spreadsheets. Working with a spreadsheet of approximately 1500 rows.
Autofilter has been applied to all columns. Several columns have been hidden.

Select one or more cells( one or more rows) and attempt to Insert cells
this option is not available( greyed out). We do have an option to insert
rows, but NOT what we need to do.

This works in other workbooks. Only issue is with current workbook.

Anyone seen this before? CAn you point me toward a cause and correction?

Thanks for your ideas and suggestions

--

Dave Peterson