In some of my spread sheets, when I click on a single cell, Excel highlights
multiple connecting cells at the same time. (sometimes two, three, or four)
Always vertically, not horizontally.

What causes this, and how can I fix it?
(it's really a pain in the...and makes working on individual cells difficult.)

Hi,

You may be accidentally tapping F8. Tap it again when this happens.

Mike

"BoomerD" wrote:

In some of my spread sheets, when I click on a single cell, Excel highlights
multiple connecting cells at the same time. (sometimes two, three, or four)
Always vertically, not horizontally.

What causes this, and how can I fix it?
(it's really a pain in the...and makes working on individual cells difficult.)

Look to the bottom left of your Excel window where you see NUM are there
any other function names there?, if EXT is there then hit F11 and things
should be back to normal.

BoomerD;259953 Wrote:
In some of my spread sheets, when I click on a single cell, Excel
highlights
multiple connecting cells at the same time. (sometimes two, three, or
four)
Always vertically, not horizontally.

What causes this, and how can I fix it?
(it's really a pain in the...and makes working on individual cells
difficult.)


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=72578

Hi,

I don't think you want F11 - that is Insert Chart.

You can cancel Extend mode with either F8 or Esc

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Simon Lloyd" wrote:


Look to the bottom left of your Excel window where you see NUM are there
any other function names there?, if EXT is there then hit F11 and things
should be back to normal.

BoomerD;259953 Wrote:
In some of my spread sheets, when I click on a single cell, Excel
highlights
multiple connecting cells at the same time. (sometimes two, three, or
four)
Always vertically, not horizontally.

What causes this, and how can I fix it?
(it's really a pain in the...and makes working on individual cells
difficult.)


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=72578

Always vertical, not horizontal certainly rules out being in Extended mode
as others have suggested.

If using Excel 2007 it has been reported that changing the Zoom level a bit
will stop the multi-cell selection.


Gord Dibben MS Excel MVP

On Sat, 7 Mar 2009 12:22:00 -0800, BoomerD
wrote:

In some of my spread sheets, when I click on a single cell, Excel highlights
multiple connecting cells at the same time. (sometimes two, three, or four)
Always vertically, not horizontally.

What causes this, and how can I fix it?
(it's really a pain in the...and makes working on individual cells difficult.)

Shane, thanks it was a typo! :)Shane Devenshire;260091 Wrote:
Hi,

I don't think you want F11 - that is Insert Chart.

You can cancel Extend mode with either F8 or Esc

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Simon Lloyd" wrote:


Look to the bottom left of your Excel window where you see NUM are
there
any other function names there?, if EXT is there then hit F11 and
things
should be back to normal.

BoomerD;259953 Wrote:
In some of my spread sheets, when I click on a single cell, Excel
highlights
multiple connecting cells at the same time. (sometimes two, three,
or
four)
Always vertically, not horizontally.

What causes this, and how can I fix it?
(it's really a pain in the...and makes working on individual cells
difficult.)


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' ('The Code Cage' (http://www.thecodecage.com))

------------------------------------------------------------------------
Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon
Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1)
View this thread: 'Intermittant problem - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...ad.php?t=72578)




--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=72578

Thanks for the suggestions.

I'll check this out later and report back.

As you can imagine, it makes working with functions and such...awkward at
best.


FWIW, this happens when using a mouse click, not keyboard to select cells.

If only with mouse, it's definitely not the F8 Extended mode problem.

In Extended mode, moving with the arrow keys also selects cells.

That should narrow it down.


Gord

On Sun, 8 Mar 2009 11:17:01 -0700, BoomerD
wrote:

Thanks for the suggestions.

I'll check this out later and report back.

As you can imagine, it makes working with functions and such...awkward at
best.


FWIW, this happens when using a mouse click, not keyboard to select cells.

"Gord Dibben" wrote:

Always vertical, not horizontal certainly rules out being in Extended mode
as others have suggested.

If using Excel 2007 it has been reported that changing the Zoom level a bit
will stop the multi-cell selection.



Now THIS is odd.
At 80%, it selects 2 cells.
At 90% it selects 3 cells.
At 100 and 110% it selects 4 cells.
At 120%, it only selects 1 cell.

What the heck causes this?
It doesn't happen in all spreadsheets, but once it happens in one, it ALWAYS
happens in that sheet, and in the same place.(s)
Gord Dibben MS Excel MVP

On Sat, 7 Mar 2009 12:22:00 -0800, BoomerD
wrote:

In some of my spread sheets, when I click on a single cell, Excel highlights
multiple connecting cells at the same time. (sometimes two, three, or four)
Always vertically, not horizontally.

What causes this, and how can I fix it?
(it's really a pain in the...and makes working on individual cells difficult.)

A quick correction.
At 110%, it highlights 5 cells...

Unfortunately, my eyes won't let me work at much less than 80%, and more
than 120% gets unwieldy.

I don't know the cause and haven't worked with 2007 long enough to see the
problem arise.

No idea where to go from here.

Anybody?


Gord

On Sun, 8 Mar 2009 14:20:01 -0700, BoomerD
wrote:



"Gord Dibben" wrote:

Always vertical, not horizontal certainly rules out being in Extended mode
as others have suggested.

If using Excel 2007 it has been reported that changing the Zoom level a bit
will stop the multi-cell selection.



Now THIS is odd.
At 80%, it selects 2 cells.
At 90% it selects 3 cells.
At 100 and 110% it selects 4 cells.
At 120%, it only selects 1 cell.

What the heck causes this?
It doesn't happen in all spreadsheets, but once it happens in one, it ALWAYS
happens in that sheet, and in the same place.(s)
Gord Dibben MS Excel MVP

On Sat, 7 Mar 2009 12:22:00 -0800, BoomerD
wrote:

In some of my spread sheets, when I click on a single cell, Excel highlights
multiple connecting cells at the same time. (sometimes two, three, or four)
Always vertically, not horizontally.

What causes this, and how can I fix it?
(it's really a pain in the...and makes working on individual cells difficult.)