How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask namstech Your Own Question
namstech
namstech, Electrical Engineer
Category: Microsoft Office
Satisfied Customers: 2126
Experience:  Expert in Microsoft Word, Excel, Powerpoint, Visio
31303650
Type Your Microsoft Office Question Here...
namstech is online now
A new question is answered every 9 seconds

In MS Excel 2007 and now in 2010, when I select one cell, at

Resolved Question:

In MS Excel 2007 and now in 2010, when I select one cell, at least one or more cells are selected.
Windows XP Pro
MS Exel 2010
Submitted: 5 years ago.
Category: Microsoft Office
Expert:  namstech replied 5 years ago.

NA-eTech :

Hello, and welcome to JustAnswer!

NA-eTech :

Are you pressing any keys while you select a cell?

JACUSTOMER-9ghaqrjs- :

No, just using the track ball click.

NA-eTech :

Do you get such problem in any other programs as well?

JACUSTOMER-9ghaqrjs- :

No, just excel.

JACUSTOMER-9ghaqrjs- :

I should have said, more than one cell is selected most of time, but not always

NA-eTech :

Do you have any button other than the track ball to left click the mouse?

JACUSTOMER-9ghaqrjs- :

No.

NA-eTech :

What happens if you click mouse over one cell?

JACUSTOMER-9ghaqrjs- :

The cell I click on and the one to the right are highlighted. The I scroll to the left and the second box is not highlighted. This is a nuisance when double-clicking to enter a formula.

NA-eTech :

Second box?

NA-eTech :

You mean when you scroll to left, the left cell is not highlighted, right?

JACUSTOMER-9ghaqrjs- :

The one to the right of the cell I want, no, the right cell.

NA-eTech :

Have you ever tried an external USB mouse?

JACUSTOMER-9ghaqrjs- :

It doesn't seem to happen on a new workbook.

JACUSTOMER-9ghaqrjs- :

No, I use the trackball exclusively

JACUSTOMER-9ghaqrjs- :

It's a USB trackball.

NA-eTech :

To verify if this is Excel problem, I would suggest you to try an external mouse if possible. To me, it doesn't seem to be a problem with Excel.

JACUSTOMER-9ghaqrjs- :

Why would that make a difference? We don't have any mice here.

NA-eTech :

There can be one possible problem i.e. Extended selection being ON.

NA-eTech :

Try pressing F8 once before you click.

NA-eTech :

Let me know if this helps.

JACUSTOMER-9ghaqrjs- :

No. It's still the same or worse, that sometimes makes three cells highlighted.

NA-eTech :

Press once more to toggle it back.

NA-eTech :

So it means 'extended selection' wasn't the problem. So, I would suggest you try an external mouse and see if it makes any difference.

JACUSTOMER-9ghaqrjs- :

OK, i tried an external mouse and had the same problem. Extended selection sure sounds like the right description.

JACUSTOMER-9ghaqrjs- :

You have not answered my question. Can someone else resume this chat if you're not available?

NA-eTech :

Hi again.

NA-eTech :

If you think it is the extended selection problem, you can toggle extended selection ON and OFF by pressing F8 key.

NA-eTech :

See if that makes any difference.

NA-eTech :

I will opt out in case some other expert has a better opinion about this. Thanks for your patience.

namstech and 5 other Microsoft Office Specialists are ready to help you