#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default cells selection

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

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default cells selection

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


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default cells selection

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

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default cells selection

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





  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default cells selection

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




  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default cells selection

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




  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default cells selection

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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cells Selection Darker Joyce D Excel Discussion (Misc queries) 4 November 11th 08 06:28 PM
Selection of specific cells FARAZ QURESHI Excel Discussion (Misc queries) 2 April 5th 08 09:40 AM
Copy Selection - Transpose Selection - Delete Selection Uninvisible Excel Discussion (Misc queries) 2 October 23rd 07 04:18 PM
Image behind a selection of cells?? Jonah[_2_] Excel Discussion (Misc queries) 3 July 18th 07 08:54 AM
Formatting Selection of cells. jimbob007 Excel Discussion (Misc queries) 3 February 13th 06 09:00 AM


All times are GMT +1. The time now is 06:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"