Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Cut and "insert cut cells" in Excel 2007 doesn't work.
My excel 2007 on Windows 7 operating system on my "JOb computer" seems to have a probelm with regular cut function.
When I highlight cells I want to cut and press cut (either on keyboard shortcut Ctrl+x, Home menu cut command, or from the right-click menu) cells start flashing for a split second and after that they only turn normal as if cut was not active. When I want to paste them, they paste as if copy function was used. If I try to rightclick destination cell to use function "insert cut cells" it is not one of the offered options at all. Does someone have similar problem or knows the solution? On my home computer I have same combination, Excel 2007 on windows 7 and it works just fine. But my home OS is 32-bit Win7, and on job comp it is 64-bit version. Could this have caused the problem? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cut and "insert cut cells" in Excel 2007 doesn't work.
cici1810 has brought this to us :
My excel 2007 on Windows 7 operating system on my "JOb computer" seems to have a probelm with regular cut function. When I highlight cells I want to cut and press cut (either on keyboard shortcut Ctrl+x, Home menu cut command, or from the right-click menu) cells start flashing for a split second and after that they only turn normal as if cut was not active. When I want to paste them, they paste as if copy function was used. If I try to rightclick destination cell to use function "insert cut cells" it is not one of the offered options at all. Does someone have similar problem or knows the solution? On my home computer I have same combination, Excel 2007 on windows 7 and it works just fine. But my home OS is 32-bit Win7, and on job comp it is 64-bit version. Could this have caused the problem? You only get the "Insert cut cells" menu choice when you select entire rows or cols. Otherwise, you're just moving data in cells from one location to another. Note that Excel uses CutCopyMode for this operation and so the only option you get is to "Paste" into the selected target cell[s]. If you want to actually delete/insert cells that cause a shift in the adjacent cells you need to do so before transferring your data. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cut and "insert cut cells" in Excel 2007 doesn't work.
Garry
I don't know the solution to OP's problem but I don't experience what you state may be the problem. My Excel 2007 has an "Insert Cut(or Copied)Cells" with the "shift" options when cutting/copying any range, not just entire rows or columns. Gord On Mon, 16 Apr 2012 13:27:40 -0400, GS wrote: cici1810 has brought this to us : My excel 2007 on Windows 7 operating system on my "JOb computer" seems to have a probelm with regular cut function. When I highlight cells I want to cut and press cut (either on keyboard shortcut Ctrl+x, Home menu cut command, or from the right-click menu) cells start flashing for a split second and after that they only turn normal as if cut was not active. When I want to paste them, they paste as if copy function was used. If I try to rightclick destination cell to use function "insert cut cells" it is not one of the offered options at all. Does someone have similar problem or knows the solution? On my home computer I have same combination, Excel 2007 on windows 7 and it works just fine. But my home OS is 32-bit Win7, and on job comp it is 64-bit version. Could this have caused the problem? You only get the "Insert cut cells" menu choice when you select entire rows or cols. Otherwise, you're just moving data in cells from one location to another. Note that Excel uses CutCopyMode for this operation and so the only option you get is to "Paste" into the selected target cell[s]. If you want to actually delete/insert cells that cause a shift in the adjacent cells you need to do so before transferring your data. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cut and "insert cut cells" in Excel 2007 doesn't work.
Gord Dibben explained on 4/16/2012 :
Garry I don't know the solution to OP's problem but I don't experience what you state may be the problem. My Excel 2007 has an "Insert Cut(or Copied)Cells" with the "shift" options when cutting/copying any range, not just entire rows or columns. Gord Weel you're absolutely right, Gord! I've never tried this but I see now that it works just as you say it does. Thanks for setting me straight on this.., I just love it when I learn something new!<g -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cut and "insert cut cells" in Excel 2007 doesn't work.
Just to clarify...
I usually use InsertShift at the target location and drag-n-drop the data. (I probably do this to avoid CutCopyMode and/or putting stuff on the Clipboard so that pesky TaskPane doesn't display in XL11!<g) Thus, I only use Cut for moving cols/rows around. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cut and "insert cut cells" in Excel 2007 doesn't work.
Thanks.
I set my pesky XL11 TaskPane disabled so I never see it. Gord On Mon, 16 Apr 2012 18:29:34 -0400, GS wrote: Just to clarify... I usually use InsertShift at the target location and drag-n-drop the data. (I probably do this to avoid CutCopyMode and/or putting stuff on the Clipboard so that pesky TaskPane doesn't display in XL11!<g) Thus, I only use Cut for moving cols/rows around. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I "insert copied cells"? used to be "alt i e" still work | Excel Worksheet Functions | |||
Need function that will work in Excel 2003 like "Countifs" in 2007 | Excel Worksheet Functions | |||
2007 - Column unhide in Excel does not work i.e. "Ctrl+shift+)" | Excel Discussion (Misc queries) | |||
Excel 2007 "Find" option won't work. | Excel Worksheet Functions | |||
Insert 19 cells "Shift to the right" if cell contains "-" | Excel Programming |