A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Single click selects multiple cells



 
 
Thread Tools Display Modes
  #1  
Old February 3rd, 2010, 05:43 PM posted to microsoft.public.excel.misc
Mike1558
external usenet poster
 
Posts: 12
Default Single click selects multiple cells

When clicking on a single cell multiple cells are selected. The one time
solution for this is to zoom in or out. This is problematic as 60% seems to
be the zoom that works most of the time but at this zoom level the cell
contents do not display. The time lost and the frustration that builds is
killing my productivity and office attitude. Please give all of us a permanet
fix.
--
Thanks
Mike

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc
  #2  
Old February 3rd, 2010, 05:52 PM posted to microsoft.public.excel.misc
מיכאל (מיקי) אבידן
external usenet poster
 
Posts: 562
Default Single click selects multiple cells

Try a single(!) click on [F8].
Micky



"Mike1558" wrote:

When clicking on a single cell multiple cells are selected. The one time
solution for this is to zoom in or out. This is problematic as 60% seems to
be the zoom that works most of the time but at this zoom level the cell
contents do not display. The time lost and the frustration that builds is
killing my productivity and office attitude. Please give all of us a permanet
fix.
--
Thanks
Mike

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

  #3  
Old February 3rd, 2010, 06:25 PM posted to microsoft.public.excel.misc
Jim Thomlinson
external usenet poster
 
Posts: 2,641
Default Single click selects multiple cells

Please don't post the same question multiple times. Did you try the F8? If so
and that did not work then here is a known issue in 2007

Try setting the Zoom level a little lower or higher.

The multiple cell selection is a bug in Excel 2007.

The zoom-changing appears to fix it.

A few postings have made the suggestion and it seems
to work.

Here is one such posting.

http://tinyurl.com/3wofsf


--
HTH...

Jim Thomlinson


"Mike1558" wrote:

When clicking on a single cell multiple cells are selected. The one time
solution for this is to zoom in or out. This is problematic as 60% seems to
be the zoom that works most of the time but at this zoom level the cell
contents do not display. The time lost and the frustration that builds is
killing my productivity and office attitude. Please give all of us a permanet
fix.
--
Thanks
Mike

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

  #4  
Old February 4th, 2010, 02:53 AM posted to microsoft.public.excel.misc
Mike1558
external usenet poster
 
Posts: 12
Default Single click selects multiple cells

If you read my post this is an inadequate solution. The time wasted zooming
in and out and the increasing frustration that acompanies this one time (this
is not a fix) bandaid is ruining my production and office attitude. I need a
permenant fix.
--
Thanks
Mike


"Jim Thomlinson" wrote:

Please don't post the same question multiple times. Did you try the F8? If so
and that did not work then here is a known issue in 2007

Try setting the Zoom level a little lower or higher.

The multiple cell selection is a bug in Excel 2007.

The zoom-changing appears to fix it.

A few postings have made the suggestion and it seems
to work.

Here is one such posting.

http://tinyurl.com/3wofsf


--
HTH...

Jim Thomlinson


"Mike1558" wrote:

When clicking on a single cell multiple cells are selected. The one time
solution for this is to zoom in or out. This is problematic as 60% seems to
be the zoom that works most of the time but at this zoom level the cell
contents do not display. The time lost and the frustration that builds is
killing my productivity and office attitude. Please give all of us a permanet
fix.
--
Thanks
Mike

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

  #5  
Old February 4th, 2010, 04:36 AM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Single click selects multiple cells

You won't get it here.

Wait for the fix............or maybe it has been fixed in 2010?


Gord Dibben MS Excel MVP

On Wed, 3 Feb 2010 18:53:01 -0800, Mike1558
wrote:

If you read my post this is an inadequate solution. The time wasted zooming
in and out and the increasing frustration that acompanies this one time (this
is not a fix) bandaid is ruining my production and office attitude. I need a
permenant fix.


  #6  
Old May 27th, 2010, 05:26 PM posted to microsoft.public.excel.misc
Hinson Stephens
external usenet poster
 
Posts: 3
Default Set view / display to only see one page of document.

I have done some testing and it appears that the problem exists only in Page Layout view and when there is more than one page displayed in your Excel window. If I shrink the window size and/or scroll such that only one page is displayed, the multi-select behavior stops. But if I scoll such that just the tiniest bit of another page is displayed, it starts again.

Also if I switch to Normal view, the problem stops.

Thats my $.02



Mike1558 wrote:

Single click selects multiple cells
03-Feb-10

When clicking on a single cell multiple cells are selected. The one time
solution for this is to zoom in or out. This is problematic as 60% seems to
be the zoom that works most of the time but at this zoom level the cell
contents do not display. The time lost and the frustration that builds is
killing my productivity and office attitude. Please give all of us a permanet
fix.
--
Thanks
Mike

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Previous Posts In This Thread:

On Wednesday, February 03, 2010 12:43 PM
Mike1558 wrote:

Single click selects multiple cells
When clicking on a single cell multiple cells are selected. The one time
solution for this is to zoom in or out. This is problematic as 60% seems to
be the zoom that works most of the time but at this zoom level the cell
contents do not display. The time lost and the frustration that builds is
killing my productivity and office attitude. Please give all of us a permanet
fix.
--
Thanks
Mike

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

On Wednesday, February 03, 2010 12:52 PM
????? (????) ????? wrote:

Try a single(!) click on [F8].Micky"Mike1558" wrote:
Try a single(!) click on [F8].
Micky



"Mike1558" wrote:

On Wednesday, February 03, 2010 1:25 PM
Jim Thomlinson wrote:

Please do not post the same question multiple times. Did you try the F8?
Please do not post the same question multiple times. Did you try the F8? If so
and that did not work then here is a known issue in 2007

Try setting the Zoom level a little lower or higher.

The multiple cell selection is a bug in Excel 2007.

The zoom-changing appears to fix it.

A few postings have made the suggestion and it seems
to work.

Here is one such posting.

http://tinyurl.com/3wofsf


--
HTH...

Jim Thomlinson


"Mike1558" wrote:

On Wednesday, February 03, 2010 9:53 PM
Mike1558 wrote:

If you read my post this is an inadequate solution.
If you read my post this is an inadequate solution. The time wasted zooming
in and out and the increasing frustration that acompanies this one time (this
is not a fix) bandaid is ruining my production and office attitude. I need a
permenant fix.
--
Thanks
Mike


"Jim Thomlinson" wrote:

On Wednesday, February 03, 2010 11:36 PM
Gord Dibben wrote:

You will not get it here.Wait for the fix............
You will not get it here.

Wait for the fix............or maybe it has been fixed in 2010?


Gord Dibben MS Excel MVP


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Binding Beyond the Limitation of Name Scopes
http://www.eggheadcafe.com/tutorials...nd-the-li.aspx
  #7  
Old May 27th, 2010, 05:33 PM posted to microsoft.public.excel.misc
Hinson Stephens
external usenet poster
 
Posts: 3
Default ** - Set view / display to only see one page of document

** Fixing the wrap problem - Guess you have to add your own breaks.

I have done some testing and it appears that the problem
exists only in Page Layout view and when there is more
than one page displayed in your Excel window. If I
shrink the window size and/or scroll such that only one
page is displayed, the multi-select behavior stops. But
if I scoll such that just the tiniest bit of another
page is displayed, it starts again.

Also if I switch to Normal view, the problem stops.
Bummer - still happens on Excel 2010.





Hinson Stephens wrote:

Set view / display to only see one page of document.
27-May-10

I have done some testing and it appears that the problem exists only in Page Layout view and when there is more than one page displayed in your Excel window. If I shrink the window size and/or scroll such that only one page is displayed, the multi-select behavior stops. But if I scoll such that just the tiniest bit of another page is displayed, it starts again.

Also if I switch to Normal view, the problem stops.

Thats my $.02

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Customized Find Control for FlowDocuments
http://www.eggheadcafe.com/tutorials...ind-contr.aspx
  #8  
Old May 27th, 2010, 05:34 PM posted to microsoft.public.excel.misc
Hinson Stephens
external usenet poster
 
Posts: 3
Default Not fixed in 2010, but see workaround above.

Still happens in Excel 2010 - annoying!



Gord Dibben wrote:

You will not get it here.Wait for the fix............
03-Feb-10

You will not get it here.

Wait for the fix............or maybe it has been fixed in 2010?


Gord Dibben MS Excel MVP

Previous Posts In This Thread:

On Wednesday, February 03, 2010 12:43 PM
Mike1558 wrote:

Single click selects multiple cells
When clicking on a single cell multiple cells are selected. The one time
solution for this is to zoom in or out. This is problematic as 60% seems to
be the zoom that works most of the time but at this zoom level the cell
contents do not display. The time lost and the frustration that builds is
killing my productivity and office attitude. Please give all of us a permanet
fix.
--
Thanks
Mike

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

On Wednesday, February 03, 2010 12:52 PM
????? (????) ????? wrote:

Try a single(!) click on [F8].Micky"Mike1558" wrote:
Try a single(!) click on [F8].
Micky



"Mike1558" wrote:

On Wednesday, February 03, 2010 1:25 PM
Jim Thomlinson wrote:

Please do not post the same question multiple times. Did you try the F8?
Please do not post the same question multiple times. Did you try the F8? If so
and that did not work then here is a known issue in 2007

Try setting the Zoom level a little lower or higher.

The multiple cell selection is a bug in Excel 2007.

The zoom-changing appears to fix it.

A few postings have made the suggestion and it seems
to work.

Here is one such posting.

http://tinyurl.com/3wofsf


--
HTH...

Jim Thomlinson


"Mike1558" wrote:

On Wednesday, February 03, 2010 9:53 PM
Mike1558 wrote:

If you read my post this is an inadequate solution.
If you read my post this is an inadequate solution. The time wasted zooming
in and out and the increasing frustration that acompanies this one time (this
is not a fix) bandaid is ruining my production and office attitude. I need a
permenant fix.
--
Thanks
Mike


"Jim Thomlinson" wrote:

On Wednesday, February 03, 2010 11:36 PM
Gord Dibben wrote:

You will not get it here.Wait for the fix............
You will not get it here.

Wait for the fix............or maybe it has been fixed in 2010?


Gord Dibben MS Excel MVP

On Thursday, May 27, 2010 12:26 PM
Hinson Stephens wrote:

Set view / display to only see one page of document.
I have done some testing and it appears that the problem exists only in Page Layout view and when there is more than one page displayed in your Excel window. If I shrink the window size and/or scroll such that only one page is displayed, the multi-select behavior stops. But if I scoll such that just the tiniest bit of another page is displayed, it starts again.

Also if I switch to Normal view, the problem stops.

Thats my $.02

On Thursday, May 27, 2010 12:33 PM
Hinson Stephens wrote:

** - Set view / display to only see one page of document
** Fixing the wrap problem - Guess you have to add your own breaks.

I have done some testing and it appears that the problem
exists only in Page Layout view and when there is more
than one page displayed in your Excel window. If I
shrink the window size and/or scroll such that only one
page is displayed, the multi-select behavior stops. But
if I scoll such that just the tiniest bit of another
page is displayed, it starts again.

Also if I switch to Normal view, the problem stops.
Bummer - still happens on Excel 2010.


Submitted via EggHeadCafe - Software Developer Portal of Choice
Server Side Processing in ADO.NET/WCF Data Services
http://www.eggheadcafe.com/tutorials...essing-in.aspx
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:34 PM.


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