ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   'sticky' cell selection (https://www.excelbanter.com/excel-discussion-misc-queries/52689-sticky-cell-selection.html)

yippeekiay

'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.

Paul B

'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.




David McRitchie

'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.







All times are GMT +1. The time now is 10:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com