Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combination of / and 8 deletes the column
I have found that I occassionally hit the / and the 8 key together (by
mistake) and that it deletes the column. Is this supposed to happen? Is there any way to turn the feature off? I know that the best way to avoid the deleted column is to not use that combination of keys, but mistakes happen. I am using Excel 2007 Thanks den |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combination of / and 8 deletes the column
In Excel 2007 the numpad / functions like the alt key to access items on the
quick command menu and the ribbon. If you click the down arrow on the command shortcut tab on the uppermost bar (above the ribbon at the top of the window) I'm guessing you have 'delete sheet columns' as one of the commands. With numlock on, hitting numpad 8 will activate this command when it is the 8th command on that shortcut bar. Since turning numlock off is not really a good solution and those two keys are right next to each other, I can see this happening. By unchecking multiple commands, then rechecking them in a particular order, you can rearrange that command shortcut bar to put 8 as something more harmless, otherwise if you still want to use the 9th command but know you'll continue to hit those buttons together, create a macro that does nothing and assign it to the 8th spot, then assign something to the 9th spot. " wrote: I have found that I occassionally hit the / and the 8 key together (by mistake) and that it deletes the column. Is this supposed to happen? Is there any way to turn the feature off? I know that the best way to avoid the deleted column is to not use that combination of keys, but mistakes happen. I am using Excel 2007 Thanks den |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combination of / and 8 deletes the column
Also, if you put alt T then letter O, this will take you to the options menu.
On the advanced tab at the bottom under 'Lotus Compatability' you will find "Microsoft Office Excel Menu Key:" with / in the field. Delete the / and it won't have that function anymore. "~L" wrote: In Excel 2007 the numpad / functions like the alt key to access items on the quick command menu and the ribbon. If you click the down arrow on the command shortcut tab on the uppermost bar (above the ribbon at the top of the window) I'm guessing you have 'delete sheet columns' as one of the commands. With numlock on, hitting numpad 8 will activate this command when it is the 8th command on that shortcut bar. Since turning numlock off is not really a good solution and those two keys are right next to each other, I can see this happening. By unchecking multiple commands, then rechecking them in a particular order, you can rearrange that command shortcut bar to put 8 as something more harmless, otherwise if you still want to use the 9th command but know you'll continue to hit those buttons together, create a macro that does nothing and assign it to the 8th spot, then assign something to the 9th spot. " wrote: I have found that I occassionally hit the / and the 8 key together (by mistake) and that it deletes the column. Is this supposed to happen? Is there any way to turn the feature off? I know that the best way to avoid the deleted column is to not use that combination of keys, but mistakes happen. I am using Excel 2007 Thanks den |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combination of / and 8 deletes the column
On Oct 16, 12:26*pm, ~L wrote:
Also, if you put alt T then letter O, this will take you to the options menu. *On the advanced tab at the bottom under 'Lotus Compatability' you will find "Microsoft Office Excel Menu Key:" with / in the field. *Delete the / and it won't have that function anymore. "~L" wrote: In Excel 2007 the numpad / functions like the alt key to access items on the quick command menu and the ribbon. *If you click the down arrow on the command shortcut tab on the uppermost bar (above the ribbon at the top of the window) I'm guessing you have 'delete sheet columns' as one of the commands. * With numlock on, hitting numpad 8 will activate this command when it is the 8th command on that shortcut bar. * Since turning numlock off is not really a good solution and those two keys are right next to each other, I can see this happening. By unchecking multiple commands, then rechecking them in a particular order, you can rearrange that command shortcut bar to put 8 as something more harmless, otherwise if you still want to use the 9th command but know you'll continue to hit those buttons together, create a macro that does nothing and assign it to the 8th spot, then assign something to the 9th spot. " wrote: I have found that I occassionally hit the / and the 8 key together (by mistake) and that it deletes the column. *Is this supposed to happen? Is there any way to turn the feature off? *I know that the best way to avoid the deleted column is to not use that combination of keys, but mistakes happen. I am using Excel 2007 Thanks den- Hide quoted text - - Show quoted text - Thank you very much! That explains why it happened so many times in August. I turned off the feature, per your second suggestion. Again, thank you. den |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combination of / and 8 deletes the column
On Oct 16, 1:18*pm, wrote:
On Oct 16, 12:26*pm, ~L wrote: Also, if you put alt T then letter O, this will take you to the options menu. *On the advanced tab at the bottom under 'Lotus Compatability' you will find "Microsoft Office Excel Menu Key:" with / in the field. *Delete the / and it won't have that function anymore. "~L" wrote: In Excel 2007 the numpad / functions like the alt key to access items on the quick command menu and the ribbon. *If you click the down arrow on the command shortcut tab on the uppermost bar (above the ribbon at the top of the window) I'm guessing you have 'delete sheet columns' as one of the commands. * With numlock on, hitting numpad 8 will activate this command when it is the 8th command on that shortcut bar. * Since turning numlock off is not really a good solution and those two keys are right next to each other, I can see this happening. By unchecking multiple commands, then rechecking them in a particular order, you can rearrange that command shortcut bar to put 8 as something more harmless, otherwise if you still want to use the 9th command but know you'll continue to hit those buttons together, create a macro that does nothing and assign it to the 8th spot, then assign something to the 9th spot. " wrote: I have found that I occassionally hit the / and the 8 key together (by mistake) and that it deletes the column. *Is this supposed to happen? Is there any way to turn the feature off? *I know that the best way to avoid the deleted column is to not use that combination of keys, but mistakes happen. I am using Excel 2007 Thanks den- Hide quoted text - - Show quoted text - Thank you very much! *That explains why it happened so many times in August. *I turned off the feature, per your second suggestion. Again, thank you. den- Hide quoted text - - Show quoted text - Also, you were right on about the delete column command on the ribbon. It occupies the number eight place and was being activated by my hitting the /. dt |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combination of / and 8 deletes the column
Glad I could help!
" wrote: On Oct 16, 1:18 pm, wrote: On Oct 16, 12:26 pm, ~L wrote: Also, if you put alt T then letter O, this will take you to the options menu. On the advanced tab at the bottom under 'Lotus Compatability' you will find "Microsoft Office Excel Menu Key:" with / in the field. Delete the / and it won't have that function anymore. "~L" wrote: In Excel 2007 the numpad / functions like the alt key to access items on the quick command menu and the ribbon. If you click the down arrow on the command shortcut tab on the uppermost bar (above the ribbon at the top of the window) I'm guessing you have 'delete sheet columns' as one of the commands. With numlock on, hitting numpad 8 will activate this command when it is the 8th command on that shortcut bar. Since turning numlock off is not really a good solution and those two keys are right next to each other, I can see this happening. By unchecking multiple commands, then rechecking them in a particular order, you can rearrange that command shortcut bar to put 8 as something more harmless, otherwise if you still want to use the 9th command but know you'll continue to hit those buttons together, create a macro that does nothing and assign it to the 8th spot, then assign something to the 9th spot. " wrote: I have found that I occassionally hit the / and the 8 key together (by mistake) and that it deletes the column. Is this supposed to happen? Is there any way to turn the feature off? I know that the best way to avoid the deleted column is to not use that combination of keys, but mistakes happen. I am using Excel 2007 Thanks den- Hide quoted text - - Show quoted text - Thank you very much! That explains why it happened so many times in August. I turned off the feature, per your second suggestion. Again, thank you. den- Hide quoted text - - Show quoted text - Also, you were right on about the delete column command on the ribbon. It occupies the number eight place and was being activated by my hitting the /. dt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combination Column and Stacked Column Chart in XL 2007 | Charts and Charting in Excel | |||
A combination chart of column with a stacked column | Excel Discussion (Misc queries) | |||
column-line combination charts | Excel Discussion (Misc queries) | |||
combination x-y scatter and column graph | Charts and Charting in Excel | |||
combination of stacked and clustered column | Charts and Charting in Excel |