Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Recently, the Control+Space keyboard combination to select a column in
Excel (2003) stopped working. The Control and Space keys work fine on their own and all other Control combinations work. Shift+Space for row selection works also. I'm not sure what I changed on my system to prompt this change, but "Detect and Repair..." doesn't do anything, even if I have it reset all my customization. I've tried removing all my Add-Ins, customized toolbars, and Personal Macro Book to no avail. I have the EXACT same configuration on my laptop and Ctrl+Space works fine on that machine. I've been working with Excel for years and have never seen this behavior. Does anyone have any ideas? Thanks in advance. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
It sounds like you tried all the things I would try.
But maybe you missed one. If you start excel in safe mode: windows start button|Run excel /safe And then just test it there, does it work? Maybe you missed an addin. MPW wrote: Recently, the Control+Space keyboard combination to select a column in Excel (2003) stopped working. The Control and Space keys work fine on their own and all other Control combinations work. Shift+Space for row selection works also. I'm not sure what I changed on my system to prompt this change, but "Detect and Repair..." doesn't do anything, even if I have it reset all my customization. I've tried removing all my Add-Ins, customized toolbars, and Personal Macro Book to no avail. I have the EXACT same configuration on my laptop and Ctrl+Space works fine on that machine. I've been working with Excel for years and have never seen this behavior. Does anyone have any ideas? Thanks in advance. -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks Dave,
I gave that a shot to no avail. Even in safe mode, I still can't select a whole column with Ctrl-Space. I'm about at the point of writing a macro to put that functionality back into Excel, but I'd really like to know exactly how this one key combination stopped working. Thanks for your help! On Oct 22, 10:25 am, Dave Peterson wrote: It sounds like you tried all the things I would try. But maybe you missed one. If you start excel in safe mode: windows start button|Run excel /safe And then just test it there, does it work? Maybe you missed an addin. MPW wrote: Recently, the Control+Space keyboard combination to select a column in Excel (2003) stopped working. The Control and Space keys work fine on their own and all other Control combinations work. Shift+Space for row selection works also. I'm not sure what I changed on my system to prompt this change, but "Detect and Repair..." doesn't do anything, even if I have it reset all my customization. I've tried removing all my Add-Ins, customized toolbars, and Personal Macro Book to no avail. I have the EXACT same configuration on my laptop and Ctrl+Space works fine on that machine. I've been working with Excel for years and have never seen this behavior. Does anyone have any ideas? Thanks in advance.-- Dave Peterson- Hide quoted text -- Show quoted text - |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Can you swap keyboards?
MPW wrote: Thanks Dave, I gave that a shot to no avail. Even in safe mode, I still can't select a whole column with Ctrl-Space. I'm about at the point of writing a macro to put that functionality back into Excel, but I'd really like to know exactly how this one key combination stopped working. Thanks for your help! On Oct 22, 10:25 am, Dave Peterson wrote: It sounds like you tried all the things I would try. But maybe you missed one. If you start excel in safe mode: windows start button|Run excel /safe And then just test it there, does it work? Maybe you missed an addin. MPW wrote: Recently, the Control+Space keyboard combination to select a column in Excel (2003) stopped working. The Control and Space keys work fine on their own and all other Control combinations work. Shift+Space for row selection works also. I'm not sure what I changed on my system to prompt this change, but "Detect and Repair..." doesn't do anything, even if I have it reset all my customization. I've tried removing all my Add-Ins, customized toolbars, and Personal Macro Book to no avail. I have the EXACT same configuration on my laptop and Ctrl+Space works fine on that machine. I've been working with Excel for years and have never seen this behavior. Does anyone have any ideas? Thanks in advance.-- Dave Peterson- Hide quoted text -- Show quoted text - -- Dave Peterson |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() MPW schreef: Recently, the Control+Space keyboard combination to select a column in Excel (2003) stopped working. The Control and Space keys work fine on their own and all other Control combinations work. Shift+Space for row selection works also. I'm not sure what I changed on my system to prompt this change, but "Detect and Repair..." doesn't do anything, even if I have it reset all my customization. I've tried removing all my Add-Ins, customized toolbars, and Personal Macro Book to no avail. I have the EXACT same configuration on my laptop and Ctrl+Space works fine on that machine. I've been working with Excel for years and have never seen this behavior. Does anyone have any ideas? Thanks in advance. I have the same problem! Not only in excel, but in other programs as well. I can still do it this way: Push RIGHT-CRTL+SPACE, release SPACE, push LEFT-CTRL, release RIGHT-CRTL, push SPACE.... Any ideas? I think its a windows setting. |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() |
#9
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Kris,
I'm experiencing this same behavior. Ctrl+Space doesn't work, however your sequence does work. I can get Ctrl+Space to work if I hold down one of the Ctrl keys, hit and release Space, hold down the other Ctrl key, release the first Ctrl key and hit Space again. That selects the column. This is really odd. I checked the keyboard settings and they are normal too. Anyone have any further advice? Thanks for the help so far. - MPW wrote: MPW schreef: Recently, the Control+Space keyboard combination to select a column in Excel (2003) stopped working. The Control and Space keys work fine on their own and all other Control combinations work. Shift+Space for row selection works also. I'm not sure what I changed on my system to prompt this change, but "Detect and Repair..." doesn't do anything, even if I have it reset all my customization. I've tried removing all my Add-Ins, customized toolbars, and Personal Macro Book to no avail. I have the EXACT same configuration on my laptop and Ctrl+Space works fine on that machine. I've been working with Excel for years and have never seen this behavior. Does anyone have any ideas? Thanks in advance. I have the same problem! Not only in excel, but in other programs as well. I can still do it this way: Push RIGHT-CRTL+SPACE, release SPACE, push LEFT-CTRL, release RIGHT-CRTL, push SPACE.... Any ideas? I think its a windows setting. |
#10
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In . com, MPW
spake thusly: Dman, All Accessibility Options are turned off, always have been. I'm throughly confused. I'm going to try Dave's suggestion of swapping keyboards once I find a spare. Thanks for the feedback. Wish I had more ideas, but I don't. Windows Auto-Updates? (I.e., a bug in same.) -dman- ==================== Dallman Ross wrote: In . com, spake thusly: MPW schreef: Recently, the Control+Space keyboard combination to select a column in Excel (2003) stopped working. The Control and Space keys work fine on their own and all other Control combinations work. Shift+Space for row selection works also. I have the same problem! Not only in excel, but in other programs as well. I can still do it this way: Push RIGHT-CRTL+SPACE, release SPACE, push LEFT-CTRL, release RIGHT-CRTL, push SPACE.... Any ideas? I think its a windows setting. I'm wondering if you two haven't inadvertently turned on Windows' Accessibility Options. (They can get turned on if one absent-mindedly rests on one of the trigger keys, such as Ctrl, for quite a few seconds.) Go to the Control Panel and find Accessibility Options, open them and turn them off if they're on. (And report back here -- I'm now curious.) -dman- |
#11
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() MPW wrote: Kris, I'm experiencing this same behavior. Ctrl+Space doesn't work, however your sequence does work. I can get Ctrl+Space to work if I hold down one of the Ctrl keys, hit and release Space, hold down the other Ctrl key, release the first Ctrl key and hit Space again. That selects the column. This is really odd. I checked the keyboard settings and they are normal too. Anyone have any further advice? Thanks for the help so far. - MPW wrote: MPW schreef: Recently, the Control+Space keyboard combination to select a column in Excel (2003) stopped working. The Control and Space keys work fine on their own and all other Control combinations work. Shift+Space for row selection works also. I'm not sure what I changed on my system to prompt this change, but "Detect and Repair..." doesn't do anything, even if I have it reset all my customization. I've tried removing all my Add-Ins, customized toolbars, and Personal Macro Book to no avail. I have the EXACT same configuration on my laptop and Ctrl+Space works fine on that machine. I've been working with Excel for years and have never seen this behavior. Does anyone have any ideas? Thanks in advance. I have the same problem! Not only in excel, but in other programs as well. I can still do it this way: Push RIGHT-CRTL+SPACE, release SPACE, push LEFT-CTRL, release RIGHT-CRTL, push SPACE.... Any ideas? I think its a windows setting. On my pc it turned out a Logitec video process that was doing this. I killed the process and the problem stopped. I then unistalled the Logitech webcam. Kris |
#12
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
kris
Thanks for reporting the fix in your case. Now we have it archived on google. Gord Dibben MS Excel MVP On 22 Nov 2006 03:59:58 -0800, wrote: MPW wrote: Kris, I'm experiencing this same behavior. Ctrl+Space doesn't work, however your sequence does work. I can get Ctrl+Space to work if I hold down one of the Ctrl keys, hit and release Space, hold down the other Ctrl key, release the first Ctrl key and hit Space again. That selects the column. This is really odd. I checked the keyboard settings and they are normal too. Anyone have any further advice? Thanks for the help so far. - MPW wrote: MPW schreef: Recently, the Control+Space keyboard combination to select a column in Excel (2003) stopped working. The Control and Space keys work fine on their own and all other Control combinations work. Shift+Space for row selection works also. I'm not sure what I changed on my system to prompt this change, but "Detect and Repair..." doesn't do anything, even if I have it reset all my customization. I've tried removing all my Add-Ins, customized toolbars, and Personal Macro Book to no avail. I have the EXACT same configuration on my laptop and Ctrl+Space works fine on that machine. I've been working with Excel for years and have never seen this behavior. Does anyone have any ideas? Thanks in advance. I have the same problem! Not only in excel, but in other programs as well. I can still do it this way: Push RIGHT-CRTL+SPACE, release SPACE, push LEFT-CTRL, release RIGHT-CRTL, push SPACE.... Any ideas? I think its a windows setting. On my pc it turned out a Logitec video process that was doing this. I killed the process and the problem stopped. I then unistalled the Logitech webcam. Kris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how can i multiply two columns | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
match and count words | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions |