Insert cells option unavailable?
 

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

Insert cells option unavailable?
 

Sorry folks, I forgot to include with original post
Using Excel XP running on WinXP

"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

Insert cells option unavailable?
 

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

Insert cells option unavailable?
 

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

Insert cells option unavailable?
 

I don't remember ever seeing a way to shift the cells down if there was an
autofilter applied and some rows were hidden.

I don't think of this as a problem to be fixed, though.

Not much help, huh?

JR Hester wrote:

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


--

Dave Peterson

Insert cells option unavailable?
 

I don't kn ow whether any ROWS were hidden or not. I did test with autofilter
applied to ALL columns with 3 COLUMNS hidden and was able to INSERT CELLS
and shift cells down without any problem. Your mention of hidden ROWS however
gives me something else to test. That may have been a fact that OP did not
realize or was not AWARE of.

Thanks for your idea. I will advise of my test results with Hidden rows.
Thanks again.

"Dave Peterson" wrote:

I don't remember ever seeing a way to shift the cells down if there was an
autofilter applied and some rows were hidden.

I don't think of this as a problem to be fixed, though.

Not much help, huh?

JR Hester wrote:

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


--

Dave Peterson

Insert cells option unavailable?
 

Just tested a spreadsheet with 5000 rows of data. Hid rows 11 through 19,
turned on autofilter. Selected cells f5, g5, and h5, Insertcellsshift down
no problem.
Verified my Excel version-- XP SP3
Tested OPs rememberance of deleting some rows WHILE filter was applied and
truly it does then eliminate the Cells option ffrom teh insert menu. EVEN if
you select a range below where the rows were deleted. SBT-- Strange but True.

MAybe this thread will help someone else down the road.


"Dave Peterson" wrote:

I don't remember ever seeing a way to shift the cells down if there was an
autofilter applied and some rows were hidden.

I don't think of this as a problem to be fixed, though.

Not much help, huh?

JR Hester wrote:

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


--

Dave Peterson

Insert cells option unavailable?
 

When I mentioned that rows were hidden, I meant that they were hidden by using
the autofilter arrows--not by manually hiding them.



JR Hester wrote:

Just tested a spreadsheet with 5000 rows of data. Hid rows 11 through 19,
turned on autofilter. Selected cells f5, g5, and h5, Insertcellsshift down
no problem.
Verified my Excel version-- XP SP3
Tested OPs rememberance of deleting some rows WHILE filter was applied and
truly it does then eliminate the Cells option ffrom teh insert menu. EVEN if
you select a range below where the rows were deleted. SBT-- Strange but True.

MAybe this thread will help someone else down the road.

"Dave Peterson" wrote:

I don't remember ever seeing a way to shift the cells down if there was an
autofilter applied and some rows were hidden.

I don't think of this as a problem to be fixed, though.

Not much help, huh?

JR Hester wrote:

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


--

Dave Peterson


--

Dave Peterson