Single click selects multiple cells

  • Thread starter Thread starter Mike1558
  • Start date Start date
M

Mike1558

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/com...0-8652e2432451&dg=microsoft.public.excel.misc
 
Try a single(!) click on [F8].
Micky
 
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
 
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.
 
You won't get it here.

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


Gord Dibben MS Excel MVP
 
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 tim
solution for this is to zoom in or out. This is problematic as 60% seems t
be the zoom that works most of the time but at this zoom level the cel
contents do not display. The time lost and the frustration that builds i
killing my productivity and office attitude. Please give all of us a permane
fix
-
Thank
Mik

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

http://www.microsoft.com/office/com...0-8652e2432451&dg=microsoft.public.excel.misc

Previous Posts In This Thread:

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

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

http://www.microsoft.com/office/com...0-8652e2432451&dg=microsoft.public.excel.misc

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


:

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 s
and that did not work then here is a known issue in 200

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 seem
to work

Here is one such posting

http://tinyurl.com/3wofs

-
HTH..

Jim Thomlinso

:

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

:

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/tutorial...f-49faac8854c8/wpf-binding-beyond-the-li.aspx
 
** 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/tutorial...3-721a40cf910c/wpf-customized-find-contr.aspx
 
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:

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/com...0-8652e2432451&dg=microsoft.public.excel.misc

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



:

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


:

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


:

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

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

** - 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/tutorial...f-4f6f92a76585/server-side-processing-in.aspx
 
Back
Top