cells selection

When I use the curser to select a single cell, multiple cells are selected.
If I tab, the highlight stays within the selected cells. When I use the
arrow keys a single cell selection accures and things work okay. This
appears to be only in this worrkbook where the problem accurs on multiple
sheets though not on all sheets. I am using MS Excel 2007

Hi,

In Excel 2003 I'd tap F8 to cure that but Microsoft have probably changed
that because they can!!

Mike

"Davey" wrote:

When I use the curser to select a single cell, multiple cells are selected.
If I tab, the highlight stays within the selected cells. When I use the
arrow keys a single cell selection accures and things work okay. This
appears to be only in this worrkbook where the problem accurs on multiple
sheets though not on all sheets. I am using MS Excel 2007

Try setting the Zoom level a little lower.

The multiple cell selection is a bug in Excel 2007.

The zoom-changing appears to fix it.

I don't have 2007 but a few postings have made the suggestion and it seems
to work.

Here is one such posting.

http://tinyurl.com/3wofsf

Post back please to confirm if this works or is bogus advice.


Gord Dibben MS Excel MVP

On Tue, 23 Dec 2008 06:21:01 -0800, Davey
wrote:

When I use the curser to select a single cell, multiple cells are selected.
If I tab, the highlight stays within the selected cells. When I use the
arrow keys a single cell selection accures and things work okay. This
appears to be only in this worrkbook where the problem accurs on multiple
sheets though not on all sheets. I am using MS Excel 2007

I tried F8 but that added more cells to the selection really confusing me.
And they won't give me Excel 2003 back. One step forward two steps back!
Sort of like the state of the economy;-)

"Mike H" wrote:

Hi,

In Excel 2003 I'd tap F8 to cure that but Microsoft have probably changed
that because they can!!

Mike

"Davey" wrote:

When I use the curser to select a single cell, multiple cells are selected.
If I tab, the highlight stays within the selected cells. When I use the
arrow keys a single cell selection accures and things work okay. This
appears to be only in this worrkbook where the problem accurs on multiple
sheets though not on all sheets. I am using MS Excel 2007

Thanks for the suggestion of changing the zoom. It worked for me. I have
also found that if you minimize the spreadsheet and work on it stretched out
to full size but still minimized that works as well. Crazy annoying glitch!

Thanks again! This was very helpful.

"Gord Dibben" wrote:

Try setting the Zoom level a little lower.

The multiple cell selection is a bug in Excel 2007.

The zoom-changing appears to fix it.

I don't have 2007 but a few postings have made the suggestion and it seems
to work.

Here is one such posting.

http://tinyurl.com/3wofsf

Post back please to confirm if this works or is bogus advice.


Gord Dibben MS Excel MVP

On Tue, 23 Dec 2008 06:21:01 -0800, Davey
wrote:

When I use the curser to select a single cell, multiple cells are selected.
If I tab, the highlight stays within the selected cells. When I use the
arrow keys a single cell selection accures and things work okay. This
appears to be only in this worrkbook where the problem accurs on multiple
sheets though not on all sheets. I am using MS Excel 2007

Thanks for the feedback on the Zoom change working.


Gord

On Fri, 20 Feb 2009 14:09:01 -0800, Allyx
wrote:

Thanks for the suggestion of changing the zoom. It worked for me. I have
also found that if you minimize the spreadsheet and work on it stretched out
to full size but still minimized that works as well. Crazy annoying glitch!

Thanks again! This was very helpful.

"Gord Dibben" wrote:

Try setting the Zoom level a little lower.

The multiple cell selection is a bug in Excel 2007.

The zoom-changing appears to fix it.

I don't have 2007 but a few postings have made the suggestion and it seems
to work.

Here is one such posting.

http://tinyurl.com/3wofsf

Post back please to confirm if this works or is bogus advice.


Gord Dibben MS Excel MVP

On Tue, 23 Dec 2008 06:21:01 -0800, Davey
wrote:

When I use the curser to select a single cell, multiple cells are selected.
If I tab, the highlight stays within the selected cells. When I use the
arrow keys a single cell selection accures and things work okay. This
appears to be only in this worrkbook where the problem accurs on multiple
sheets though not on all sheets. I am using MS Excel 2007

Same exact thing was happening to me. Multiple cells were being selected,
while I only clicked on one. I changed the zoom to 90% and then back to 100%
and the bug was fixed!

"Gord Dibben" wrote:

Thanks for the feedback on the Zoom change working.


Gord

On Fri, 20 Feb 2009 14:09:01 -0800, Allyx
wrote:

Thanks for the suggestion of changing the zoom. It worked for me. I have
also found that if you minimize the spreadsheet and work on it stretched out
to full size but still minimized that works as well. Crazy annoying glitch!

Thanks again! This was very helpful.

"Gord Dibben" wrote:

Try setting the Zoom level a little lower.

The multiple cell selection is a bug in Excel 2007.

The zoom-changing appears to fix it.

I don't have 2007 but a few postings have made the suggestion and it seems
to work.

Here is one such posting.

http://tinyurl.com/3wofsf

Post back please to confirm if this works or is bogus advice.


Gord Dibben MS Excel MVP

On Tue, 23 Dec 2008 06:21:01 -0800, Davey
wrote:

When I use the curser to select a single cell, multiple cells are selected.
If I tab, the highlight stays within the selected cells. When I use the
arrow keys a single cell selection accures and things work okay. This
appears to be only in this worrkbook where the problem accurs on multiple
sheets though not on all sheets. I am using MS Excel 2007

Thanks for the confirmation.


Gord

On Wed, 22 Apr 2009 09:54:15 -0700, andalusiana
wrote:

Same exact thing was happening to me. Multiple cells were being selected,
while I only clicked on one. I changed the zoom to 90% and then back to 100%
and the bug was fixed!

"Gord Dibben" wrote:

Thanks for the feedback on the Zoom change working.


Gord

On Fri, 20 Feb 2009 14:09:01 -0800, Allyx
wrote:

Thanks for the suggestion of changing the zoom. It worked for me. I have
also found that if you minimize the spreadsheet and work on it stretched out
to full size but still minimized that works as well. Crazy annoying glitch!

Thanks again! This was very helpful.

"Gord Dibben" wrote:

Try setting the Zoom level a little lower.

The multiple cell selection is a bug in Excel 2007.

The zoom-changing appears to fix it.

I don't have 2007 but a few postings have made the suggestion and it seems
to work.

Here is one such posting.

http://tinyurl.com/3wofsf

Post back please to confirm if this works or is bogus advice.


Gord Dibben MS Excel MVP

On Tue, 23 Dec 2008 06:21:01 -0800, Davey
wrote:

When I use the curser to select a single cell, multiple cells are selected.
If I tab, the highlight stays within the selected cells. When I use the
arrow keys a single cell selection accures and things work okay. This
appears to be only in this worrkbook where the problem accurs on multiple
sheets though not on all sheets. I am using MS Excel 2007