Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
yippeekiay
 
Posts: n/a
Default '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   Report Post  
Paul B
 
Posts: n/a
Default '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   Report Post  
David McRitchie
 
Posts: n/a
Default '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.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add "left align across selection" cell formatting Monty Analyst Excel Worksheet Functions 2 November 5th 08 03:17 PM
Combo Box selection to place $0 into another cell John Excel Discussion (Misc queries) 16 July 22nd 06 01:17 PM
Cell selection not visible Mangesh Yadav Excel Discussion (Misc queries) 1 September 1st 05 01:29 PM
Cell Selection after "Enter" Synectica Excel Discussion (Misc queries) 6 August 29th 05 09:55 PM
Can a conditional cell formula reference data selection in a comb. t_nellis Excel Worksheet Functions 1 April 19th 05 04:44 PM


All times are GMT +1. The time now is 05:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"