Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert chart option unavailable...HELP | Charts and Charting in Excel | |||
Filter Blanks option unavailable | Excel Discussion (Misc queries) | |||
The worksheet option under "insert" is gray (unavailable)- why? | Excel Worksheet Functions | |||
How do I enable 'insert copied cells' (option not available in men | Excel Discussion (Misc queries) | |||
Format Option Unavailable | Excel Discussion (Misc queries) |