Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel cell problem
I have a workbook I have created (I am a novice), which for some reason, when
I want to add or delete a cell in ANY column, I no longer have the option to shift cells up or down, it will only allow me to shift the entire row up or down. Anyone have any idea what I am doing wrong here? I have some formulas set up to keep counts for me, nothing real special. Thanks in advance. -- Thanks Steve |
#2
|
|||
|
|||
Have you applied Data|filter to that worksheet?
Try data|filter|show all (to see everything) then try it out. Steve wrote: I have a workbook I have created (I am a novice), which for some reason, when I want to add or delete a cell in ANY column, I no longer have the option to shift cells up or down, it will only allow me to shift the entire row up or down. Anyone have any idea what I am doing wrong here? I have some formulas set up to keep counts for me, nothing real special. Thanks in advance. -- Thanks Steve -- Dave Peterson |
#3
|
|||
|
|||
Hi Dave,
Show all is grayed out. I tryed it highlighting the worksheet and just one column, both of which have "show all" grayed out. Any other options you can think of? -- Thanks Steve "Dave Peterson" wrote: Have you applied Data|filter to that worksheet? Try data|filter|show all (to see everything) then try it out. Steve wrote: I have a workbook I have created (I am a novice), which for some reason, when I want to add or delete a cell in ANY column, I no longer have the option to shift cells up or down, it will only allow me to shift the entire row up or down. Anyone have any idea what I am doing wrong here? I have some formulas set up to keep counts for me, nothing real special. Thanks in advance. -- Thanks Steve -- Dave Peterson |
#4
|
|||
|
|||
Is the worksheet protected?
If you're using xl2002+, the worksheet can be protected, but still allow the users to delete/insert rows or columns. Tools|Protection If you see "Unprotect sheet" Then maybe that's it! Steve wrote: Hi Dave, Show all is grayed out. I tryed it highlighting the worksheet and just one column, both of which have "show all" grayed out. Any other options you can think of? -- Thanks Steve "Dave Peterson" wrote: Have you applied Data|filter to that worksheet? Try data|filter|show all (to see everything) then try it out. Steve wrote: I have a workbook I have created (I am a novice), which for some reason, when I want to add or delete a cell in ANY column, I no longer have the option to shift cells up or down, it will only allow me to shift the entire row up or down. Anyone have any idea what I am doing wrong here? I have some formulas set up to keep counts for me, nothing real special. Thanks in advance. -- Thanks Steve -- Dave Peterson -- Dave Peterson |
#5
|
|||
|
|||
Nope, checked that too. There is no protection on the workbook or worksheet.
I am stumped. -- Thanks Steve "Dave Peterson" wrote: Is the worksheet protected? If you're using xl2002+, the worksheet can be protected, but still allow the users to delete/insert rows or columns. Tools|Protection If you see "Unprotect sheet" Then maybe that's it! Steve wrote: Hi Dave, Show all is grayed out. I tryed it highlighting the worksheet and just one column, both of which have "show all" grayed out. Any other options you can think of? -- Thanks Steve "Dave Peterson" wrote: Have you applied Data|filter to that worksheet? Try data|filter|show all (to see everything) then try it out. Steve wrote: I have a workbook I have created (I am a novice), which for some reason, when I want to add or delete a cell in ANY column, I no longer have the option to shift cells up or down, it will only allow me to shift the entire row up or down. Anyone have any idea what I am doing wrong here? I have some formulas set up to keep counts for me, nothing real special. Thanks in advance. -- Thanks Steve -- Dave Peterson -- Dave Peterson |
#6
|
|||
|
|||
I'm out of ideas.
Steve wrote: Nope, checked that too. There is no protection on the workbook or worksheet. I am stumped. -- Thanks Steve "Dave Peterson" wrote: Is the worksheet protected? If you're using xl2002+, the worksheet can be protected, but still allow the users to delete/insert rows or columns. Tools|Protection If you see "Unprotect sheet" Then maybe that's it! Steve wrote: Hi Dave, Show all is grayed out. I tryed it highlighting the worksheet and just one column, both of which have "show all" grayed out. Any other options you can think of? -- Thanks Steve "Dave Peterson" wrote: Have you applied Data|filter to that worksheet? Try data|filter|show all (to see everything) then try it out. Steve wrote: I have a workbook I have created (I am a novice), which for some reason, when I want to add or delete a cell in ANY column, I no longer have the option to shift cells up or down, it will only allow me to shift the entire row up or down. Anyone have any idea what I am doing wrong here? I have some formulas set up to keep counts for me, nothing real special. Thanks in advance. -- Thanks Steve -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set Excel cell format to "Text" from VB.NET? | Excel Discussion (Misc queries) | |||
Slight problem automating Excel in a service | Setting up and Configuration of Excel | |||
Problem Opening An Excel file. - by yk | Excel Discussion (Misc queries) | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
Copy Word table into Excel cell by cell | Excel Discussion (Misc queries) |