If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
'sticky' cell selection
When I select a cell it cannot be deselected and if i move my mouse it
selects all cells from the original. I cannot select a singular cell anywhere else on the worksheet or select any other commands. Thus the name sticky. How do I unstick my selection to carry on using the worksheet. |
#2
|
|||
|
|||
'sticky' cell selection
yippeekiay, sounds like you are in Extended Mode, EXT on in the right hand
corner or the status bay, press the F8 key to get out of it -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "yippeekiay" wrote in message ... When I select a cell it cannot be deselected and if i move my mouse it selects all cells from the original. I cannot select a singular cell anywhere else on the worksheet or select any other commands. Thus the name sticky. How do I unstick my selection to carry on using the worksheet. |
#3
|
|||
|
|||
'sticky' cell selection
If by move you mean not clicking on a cell and you see what
you described then see http://www.mvps.org/dmcritchie/excel/ghosting.txt Status Bar for a bit more familiarity of what is shown there http://www.mvps.org/dmcritchie/excel/statusbar.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Paul B" wrote in message ... yippeekiay, sounds like you are in Extended Mode, EXT on in the right hand corner or the status bay, press the F8 key to get out of it -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "yippeekiay" wrote in message ... When I select a cell it cannot be deselected and if i move my mouse it selects all cells from the original. I cannot select a singular cell anywhere else on the worksheet or select any other commands. Thus the name sticky. How do I unstick my selection to carry on using the worksheet. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can a conditional cell formula reference data selection in a comb. | t_nellis | Worksheet Functions | 1 | April 19th, 2005 04:44 PM |
IF E3 & E10 = TRUE set this cell to "Yes", else set to "No" | Timothy L | Worksheet Functions | 5 | August 27th, 2004 02:28 AM |
IF only.....IF only.... | SmokingMirror | Worksheet Functions | 8 | August 7th, 2004 07:37 PM |
Hide Specific rows. | Steve | Worksheet Functions | 7 | June 9th, 2004 09:27 PM |
Calculations based on cell selection | Shaun | Worksheet Functions | 3 | March 16th, 2004 05:39 PM |