Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What to do if the worksheet is locked on selecting rows or cells?
In Excel, sometimes when I am selecting rows or cells, the worksheet locks
and if I try to move the cursor all I do is select more rows or cells. Nothing else works. So far the only way I have found to get out of this is to reboot the whole computer. What am I doing wrong and how can I get out of this mode without rebooting? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
What to do if the worksheet is locked on selecting rows or cells?
Most often caused by hitting the F8 key and putting yourself into "Extended
Mode". If you see EXT on status bar hit F8 again to clear. Another fix can be tapping the wheel on your wheelie-mouse a few times. Gord Dibben MS Excel MVP On Tue, 9 Jan 2007 10:53:00 -0800, ALYAK wrote: In Excel, sometimes when I am selecting rows or cells, the worksheet locks and if I try to move the cursor all I do is select more rows or cells. Nothing else works. So far the only way I have found to get out of this is to reboot the whole computer. What am I doing wrong and how can I get out of this mode without rebooting? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
What to do if the worksheet is locked on selecting rows or cells?
Dave Peterson usually advises:
"Do you see EXT (short for Extend) on the status bar? If yes, try hitting F8 to toggle this setting. Some have complained that sticky mouses can do this. Try gently(!) banging on all the buttons--including the wheelmouse button." -- Noel "ALYAK" wrote in message ... In Excel, sometimes when I am selecting rows or cells, the worksheet locks and if I try to move the cursor all I do is select more rows or cells. Nothing else works. So far the only way I have found to get out of this is to reboot the whole computer. What am I doing wrong and how can I get out of this mode without rebooting? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Best Approach to Worksheet Synchronization | Excel Discussion (Misc queries) | |||
Still can select locked cells in protected sheet | New Users to Excel | |||
Order of selecting unprotected cells | Excel Discussion (Misc queries) | |||
What is fastest for this? The Small VBA or many Worksheet Functions...? | Excel Worksheet Functions | |||
embedding worksheet cells in another worksheet | Excel Discussion (Misc queries) |