PC Review


Reply
Thread Tools Rate Thread

Cursor cell selection "won't release"

 
 
nitewowl
Guest
Posts: n/a
 
      22nd Nov 2009
This is happening within an open spreadsheet. Somehow I have accidentally
hit something or some combination of keys that makes the cursor "stuck" in
selection mode. I've tried escape, enter, and a variety of combinations like
control scroll and it just won't stop. I have had this happen before though
can't remember how we got it to stop. I will print out the answer if someone
is able to tell me the trick and it works. It is a very frustrating
situation because even if you contol-alt-delete and end the program, when you
restart Excel and open the spreadsheet, it is in the same status.

I appreciate all help. Thank you.
 
Reply With Quote
 
 
 
 
Mike H
Guest
Posts: n/a
 
      22nd Nov 2009
Hi,

I'm not sure I understand but try tapping F8

Mike

"nitewowl" wrote:

> This is happening within an open spreadsheet. Somehow I have accidentally
> hit something or some combination of keys that makes the cursor "stuck" in
> selection mode. I've tried escape, enter, and a variety of combinations like
> control scroll and it just won't stop. I have had this happen before though
> can't remember how we got it to stop. I will print out the answer if someone
> is able to tell me the trick and it works. It is a very frustrating
> situation because even if you contol-alt-delete and end the program, when you
> restart Excel and open the spreadsheet, it is in the same status.
>
> I appreciate all help. Thank you.

 
Reply With Quote
 
Niek Otten
Guest
Posts: n/a
 
      22nd Nov 2009
It is not entirely clear to me what you mean with "cursor stuck", but try
function key F8

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"nitewowl" <(E-Mail Removed)> wrote in message
newsCAF970B-2040-4BC1-9B93-(E-Mail Removed)...
> This is happening within an open spreadsheet. Somehow I have accidentally
> hit something or some combination of keys that makes the cursor "stuck" in
> selection mode. I've tried escape, enter, and a variety of combinations
> like
> control scroll and it just won't stop. I have had this happen before
> though
> can't remember how we got it to stop. I will print out the answer if
> someone
> is able to tell me the trick and it works. It is a very frustrating
> situation because even if you contol-alt-delete and end the program, when
> you
> restart Excel and open the spreadsheet, it is in the same status.
>
> I appreciate all help. Thank you.


 
Reply With Quote
 
Dave Peterson
Guest
Posts: n/a
 
      22nd Nov 2009
If you're using xl2007, try changing the zoom (bottom right corner).

Back to 100% (???).

nitewowl wrote:
>
> This is happening within an open spreadsheet. Somehow I have accidentally
> hit something or some combination of keys that makes the cursor "stuck" in
> selection mode. I've tried escape, enter, and a variety of combinations like
> control scroll and it just won't stop. I have had this happen before though
> can't remember how we got it to stop. I will print out the answer if someone
> is able to tell me the trick and it works. It is a very frustrating
> situation because even if you contol-alt-delete and end the program, when you
> restart Excel and open the spreadsheet, it is in the same status.
>
> I appreciate all help. Thank you.


--

Dave Peterson
 
Reply With Quote
 
nitewowl
Guest
Posts: n/a
 
      22nd Nov 2009
It seems that a complete reboot has solved the situation. I've printed this
quick discussion though to try the F8 approach next time it happens. Thank
you both.

"Niek Otten" wrote:

> It is not entirely clear to me what you mean with "cursor stuck", but try
> function key F8
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
>
> "nitewowl" <(E-Mail Removed)> wrote in message
> newsCAF970B-2040-4BC1-9B93-(E-Mail Removed)...
> > This is happening within an open spreadsheet. Somehow I have accidentally
> > hit something or some combination of keys that makes the cursor "stuck" in
> > selection mode. I've tried escape, enter, and a variety of combinations
> > like
> > control scroll and it just won't stop. I have had this happen before
> > though
> > can't remember how we got it to stop. I will print out the answer if
> > someone
> > is able to tell me the trick and it works. It is a very frustrating
> > situation because even if you contol-alt-delete and end the program, when
> > you
> > restart Excel and open the spreadsheet, it is in the same status.
> >
> > I appreciate all help. Thank you.

>

 
Reply With Quote
 
Tom Hutchins
Guest
Posts: n/a
 
      23rd Nov 2009
Another possibility is that you accidentally activated StickyKeys mode, which
causes the effect you described. Pressing the Shift key 5 times within a few
seconds toggles StickyKeys on/off.

Hope this helps,

Hutch

"nitewowl" wrote:

> This is happening within an open spreadsheet. Somehow I have accidentally
> hit something or some combination of keys that makes the cursor "stuck" in
> selection mode. I've tried escape, enter, and a variety of combinations like
> control scroll and it just won't stop. I have had this happen before though
> can't remember how we got it to stop. I will print out the answer if someone
> is able to tell me the trick and it works. It is a very frustrating
> situation because even if you contol-alt-delete and end the program, when you
> restart Excel and open the spreadsheet, it is in the same status.
>
> I appreciate all help. Thank you.

 
Reply With Quote
 
New Member
Join Date: Sep 2010
Posts: 1
 
      6th Sep 2010
I had the same problem. I went to the list of solutions provided - none worked.

I realised that I had frozen my panes. I unfroze them and voila....it worked.

I suggest you do the same.

After it started to work I froze my panes and found the cursor to scroll freely....perhaps a bug....
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add "left align across selection" cell formatting =?Utf-8?B?TW9udHkgQW5hbHlzdA==?= Microsoft Excel Worksheet Functions 3 28th Sep 2010 05:35 PM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Microsoft Excel Misc 2 8th Aug 2008 01:54 AM
Advanced "Conditional" formatting which changes by cell selection cosva Microsoft Excel Programming 4 24th Oct 2007 04:28 PM
how to release anchored cell in EXCEL when hitting "esc" fails? =?Utf-8?B?TA==?= Microsoft Excel Misc 1 15th Apr 2006 01:03 AM
How do you select a cell with an "absolute" address with a cursor? New Daddy Microsoft Excel New Users 1 11th Aug 2005 02:19 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:55 AM.