Selection mode problem
I seem to have set Excel 2003 to a particular cell selection mode that I can't
seem to turn off. My cursor is the big plus sign and when I click on any cell in a spreadsheet - existing files or even an empty spreadsheet - the selection mode stays active and no matter where I mouse to, the selection keeps expanding. No click, right-click, shift-click, alt-click, or any keyboard command I could think of turns this off. Nothing in the menus seems appropriate, and I can't seem to find anything in the online help on this issue, so I'm obviously confusing some terminology. I would be very grateful for some advice. Thanks! Rick Trethewey |
Selection mode problem
Richard
A common cause of this is that you are in "Extended" or "Add" mode. If you see "EXT" or "ADD" down on the status bar try hitting F8 key a couple of times. F8 will will toggle you in and out of Extended mode. SHIFT + F8 will put you in "ADD" mode. With the "ADD" mode you need to re-click the mouse. This is used to select non-contiguous cells and ranges without using the CTRL key. With the "EXT" mode you just click once and drag. All cells will be selected. If you are using a wheel-mouse tap the wheel a couple times. Also see David McRitchie's "Ghosting" at http://www.mvps.org/dmcritchie/excel/ghosting.txt Gord Dibben Excel MVP On Tue, 22 Nov 2005 22:26:20 GMT, "Richard L. Trethewey" wrote: I seem to have set Excel 2003 to a particular cell selection mode that I can't seem to turn off. My cursor is the big plus sign and when I click on any cell in a spreadsheet - existing files or even an empty spreadsheet - the selection mode stays active and no matter where I mouse to, the selection keeps expanding. No click, right-click, shift-click, alt-click, or any keyboard command I could think of turns this off. Nothing in the menus seems appropriate, and I can't seem to find anything in the online help on this issue, so I'm obviously confusing some terminology. I would be very grateful for some advice. Thanks! Rick Trethewey |
Selection mode problem
Thanks for the information. It hasn't solved my problem. I did manage to
change the cursor from the hollow plus sign to the filled plus sign and now the selection is limited to one row or one column, but I can't break out of this select mode once I click in the spreadsheet. I'm stongly considering simply re-installing the software and hoping for the best. But if you think of anything else, I'd be very grateful. Thanks again! Rick Trethewey Gord Dibben wrote: Richard A common cause of this is that you are in "Extended" or "Add" mode. If you see "EXT" or "ADD" down on the status bar try hitting F8 key a couple of times. F8 will will toggle you in and out of Extended mode. SHIFT + F8 will put you in "ADD" mode. With the "ADD" mode you need to re-click the mouse. This is used to select non-contiguous cells and ranges without using the CTRL key. With the "EXT" mode you just click once and drag. All cells will be selected. If you are using a wheel-mouse tap the wheel a couple times. Also see David McRitchie's "Ghosting" at http://www.mvps.org/dmcritchie/excel/ghosting.txt Gord Dibben Excel MVP On Tue, 22 Nov 2005 22:26:20 GMT, "Richard L. Trethewey" wrote: I seem to have set Excel 2003 to a particular cell selection mode that I can't seem to turn off. My cursor is the big plus sign and when I click on any cell in a spreadsheet - existing files or even an empty spreadsheet - the selection mode stays active and no matter where I mouse to, the selection keeps expanding. No click, right-click, shift-click, alt-click, or any keyboard command I could think of turns this off. Nothing in the menus seems appropriate, and I can't seem to find anything in the online help on this issue, so I'm obviously confusing some terminology. I would be very grateful for some advice. Thanks! Rick Trethewey |
All times are GMT +1. The time now is 01:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com