|  | Cap locks and multiple selection of lines in Excell |  | |
| | | David |  |
| Posted: Mon Sep 29, 2008 5:54 pm Post subject: Cap locks and multiple selection of lines in Excell |  |
In Office 2007, in Excell, I occasionally have the program throw a fit and begin to select 2 or 3 lines or cells. I also notice at the same time, the cap lock key is reversed. When it is locked, I type in lowercase and when it is unlocked, I type in uppercase. I haven't figured out what I did to cause it or how to reverse it. I usually save the document, close the program and re-open or reboot. Other times in just seems to go away after a little while. Any clues as to what is happening? -- The more you know the less you know until the day comes you know nothing. |
| |
| | | Pegasus (MVP) |  |
| Posted: Mon Sep 29, 2008 8:20 pm Post subject: Re: Cap locks and multiple selection of lines in Excel |  |
"David" <David@discussions.microsoft.com> wrote in message news:EC838444-E5E8-420E-B810-485502EEC053@microsoft.com...
| Quote: | In Office 2007, in Excell (Excel?), I occasionally have the program throw a fit and begin to select 2 or 3 lines or cells. I also notice at the same time, the cap lock key is reversed. When it is locked, I type in lowercase and when it is unlocked, I type in uppercase. I haven't figured out what I did to cause it or how to reverse it. I usually save the document, close the program and re-open or reboot. Other times in just seems to go away after a little while. Any clues as to what is happening? -- The more you know the less you know until the day comes you know nothing.
|
Your keyboard appears to get confused. Tapping on the following six keys, one after the other, will usually fix the problem: Left Shift, Ctrl, Alt, Right Shift, Ctrl, Alt. |
| |
| | | David |  |
| Posted: Mon Sep 29, 2008 11:49 pm Post subject: Re: Cap locks and multiple selection of lines in Excel |  |
| |  | |
-- The more you know the less you know until the day comes you know nothing.
"Pegasus (MVP)" wrote:
| Quote: | "David" <David@discussions.microsoft.com> wrote in message news:EC838444-E5E8-420E-B810-485502EEC053@microsoft.com... In Office 2007, in Excell (Excel?), I occasionally have the program throw a fit and begin to select 2 or 3 lines or cells. I also notice at the same time, the cap lock key is reversed. When it is locked, I type in lowercase and when it is unlocked, I type in uppercase. I haven't figured out what I did to cause it or how to reverse it. I usually save the document, close the program and re-open or reboot. Other times in just seems to go away after a little while. Any clues as to what is happening? -- The more you know the less you know until the day comes you know nothing.
Your keyboard appears to get confused. Tapping on the following six keys, one after the other, will usually fix the problem: Left Shift, Ctrl, Alt, Right Shift, Ctrl, Alt.
My initial reaction is, "and if you'll buy that, I've got some ocean front property in Arizona . . . " Next time it happens I'll try it and see if it works. (after I throw some salt over my shoulder.) |
|
| |
| | | David |  |
| Posted: Tue Sep 30, 2008 12:34 am Post subject: Re: Cap locks and multiple selection of lines in Excel |  |
| |  | |
-- The more you know the less you know until the day comes you know nothing.
"David" wrote:
| Quote: | -- The more you know the less you know until the day comes you know nothing.
"Pegasus (MVP)" wrote:
"David" <David@discussions.microsoft.com> wrote in message news:EC838444-E5E8-420E-B810-485502EEC053@microsoft.com... In Office 2007, in Excell (Excel?), I occasionally have the program throw a fit and begin to select 2 or 3 lines or cells. I also notice at the same time, the cap lock key is reversed. When it is locked, I type in lowercase and when it is unlocked, I type in uppercase. I haven't figured out what I did to cause it or how to reverse it. I usually save the document, close the program and re-open or reboot. Other times in just seems to go away after a little while. Any clues as to what is happening? -- The more you know the less you know until the day comes you know nothing.
Your keyboard appears to get confused. Tapping on the following six keys, one after the other, will usually fix the problem: Left Shift, Ctrl, Alt, Right Shift, Ctrl, Alt.
My initial reaction is, "and if you'll buy that, I've got some ocean front property in Arizona . . . " Next time it happens I'll try it and see if it works. (after I throw some salt over my shoulder.)
|
It happened and I tried it, but nothing happened. I did discover that when I click in the upper half of a cell, it only selects the cell, but when I click on the lower half of the cell, it selects the lower adjoining cell too. Is this a feature in Excel 2007 that can be turned off and on? |
| |
| | | Pegasus (MVP) |  |
| Posted: Tue Sep 30, 2008 4:00 am Post subject: Re: Cap locks and multiple selection of lines in Excel |  |
| Quote: | It happened and I tried it, but nothing happened. I did discover that when I click in the upper half of a cell, it only selects the cell, but when I click on the lower half of the cell, it selects the lower adjoining cell too. Is this a feature in Excel 2007 that can be turned off and on?
|
Best to ask an Excel newsgroup. |
| |
|
|