Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Solved: Excel - Symptom [left mouse button click hold]


(!)

pfiltz's Avatar
pfiltz pfiltz is offline
Member with 283 posts.
THREAD STARTER
 
Join Date: Jan 2005
06-Dec-2007, 08:52 AM #1
Solved: Excel - Symptom [left mouse button click hold]
Whether it's a new spreadsheet, or an existing one, when you click anywhere on the sheet, it acts like your clicking down the left mouse button and dragging. All cells within the movement of the mouse are being selected.

Replaced the mouse, which was wireless, with a PS2 Mouse, and still have the problem.

Running Windows 2K prof SP4

MS Office 98.

Any ideas?
The Villan's Avatar
Member with 2,226 posts.
 
Join Date: Feb 2006
Location: Lincolnshire UK
06-Dec-2007, 10:18 AM #2
One possibilty is that you have turned the F8 function key on.
Try pressing the F8 function key once and see if you are now free to select wherever you want.
pfiltz's Avatar
pfiltz pfiltz is offline
Member with 283 posts.
THREAD STARTER
 
Join Date: Jan 2005
06-Dec-2007, 10:23 AM #3
Thanks... I'll take a look at that. I might even try another keyboard...
Zack Barresse's Avatar
Computer Specs
Member with 5,434 posts.
 
Join Date: Jul 2004
Location: Oregon, United States
Experience: I'ma learnin'!
06-Dec-2007, 11:24 AM #4
You're in Extended Selection mode. Toggling F8 will do that, and toggling Shift + F8 will toggle the Add Selection mode (simulates holding the Ctrl key while clicking cells, as opposed to the Shift key simulation). If the F8 combo doesn't work, although I'm fairly sure it will, replacing your keyboard might be good. Also make sure it is only your computer, just the Excel application, or just a specific file.
pfiltz's Avatar
pfiltz pfiltz is offline
Member with 283 posts.
THREAD STARTER
 
Join Date: Jan 2005
06-Dec-2007, 11:55 AM #5
Thanks folks... That seemed to fix it. I instructed the user to watch to make sure EXT is not on in the lower right hand portion of the sheet. I toggled it back and forth so they could see what effect it had on it when it was either on or off.

Appreciate it..
Zack Barresse's Avatar
Computer Specs
Member with 5,434 posts.
 
Join Date: Jul 2004
Location: Oregon, United States
Experience: I'ma learnin'!
06-Dec-2007, 11:58 AM #6
I don't believe, you may correct me if I'm wrong, but in versions prior to 2007 you will not see a distinction in the status bar between Extend and Add Selection mode. I do not have 2003 on this machine to test and my memory is lacking..
The Villan's Avatar
Member with 2,226 posts.
 
Join Date: Feb 2006
Location: Lincolnshire UK
06-Dec-2007, 12:08 PM #7
You have always had the EXT firefytr. I used to have to teach all the function key options.
I am still using Excel 2002 and EXT appears if you press F8.
pfiltz's Avatar
pfiltz pfiltz is offline
Member with 283 posts.
THREAD STARTER
 
Join Date: Jan 2005
06-Dec-2007, 12:10 PM #8
Yep, it's there, cuz I saw it, and made sure they saw it...
Zack Barresse's Avatar
Computer Specs
Member with 5,434 posts.
 
Join Date: Jul 2004
Location: Oregon, United States
Experience: I'ma learnin'!
06-Dec-2007, 12:30 PM #9
I know that. I'm asking if, when you hit Shift+ F8 if it says the same thing. They are two different modes, although I was under the impression they still showed the same mode in the status bar.

Edit: Corrected key combo.
pfiltz's Avatar
pfiltz pfiltz is offline
Member with 283 posts.
THREAD STARTER
 
Join Date: Jan 2005
06-Dec-2007, 12:33 PM #10
Didn't try the shift+f8 combo while I was there. I just pressed the F8 key off and on to show them.

Off site now...
Zack Barresse's Avatar
Computer Specs
Member with 5,434 posts.
 
Join Date: Jul 2004
Location: Oregon, United States
Experience: I'ma learnin'!
06-Dec-2007, 12:34 PM #11
Even if in Add Selection mode (the Shift + F8 combo), hitting F8 will toggle first back into Extend Selection mode (aka EXT mode) and hitting again will toggle all off. There are three settings, generally it isn't well know because it is not seen too well and people think it is "weird behavior".
The Villan's Avatar
Member with 2,226 posts.
 
Join Date: Feb 2006
Location: Lincolnshire UK
06-Dec-2007, 01:16 PM #12
Yes the ADD comes on when you do Shift F8. Again always been there
Zack Barresse's Avatar
Computer Specs
Member with 5,434 posts.
 
Join Date: Jul 2004
Location: Oregon, United States
Experience: I'ma learnin'!
06-Dec-2007, 01:23 PM #13
Quote:
Originally Posted by The Villan
Yes the ADD comes on when you do Shift F8. Again always been there
Thanks very much!!
The Villan's Avatar
Member with 2,226 posts.
 
Join Date: Feb 2006
Location: Lincolnshire UK
06-Dec-2007, 01:45 PM #14
Thats OK
slurpee55's Avatar
Computer Specs
Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
06-Dec-2007, 08:00 PM #15
Gang, what is the point of that mode? I don't know how many times I have had to "save" people who were "stuck" and frantic that they couldn't do anything in Excel....
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑