I can't select non adjacent cells using the control button
 

For some reason I am having a terrible time selecting or highlighting a group
of cells and then using the control button and selecting another group of
cells

I can't select non adjacent cells using the control button
 

Are you selecting say A1:A3 then hold CTRL key and select D1:D3?

What occurs when you try?

How about hitting SHIFT + F8 then selecting A1:A3 and D1:D3?


Gord Dibben MS Excel MVP


On Sat, 19 Sep 2009 15:24:01 -0700, mustbesimple
wrote:

For some reason I am having a terrible time selecting or highlighting a group
of cells and then using the control button and selecting another group of
cells

I can't select non adjacent cells using the control button
 

I would really like to see an answer on this. I teach Excel and on rare
occassion Excel simply doesn't work in this regard. I have the student move
to another machine and do the same thing with the same Excel sheet and it
works! Seems to be a myster to me

Control Key
 

I am experiencing the same problem. My 2003 version is fine. It is strictly limited to my 2007 version...anyone help?



KjenkinJC wrote:

I would really like to see an answer on this.
08-Oct-09

I would really like to see an answer on this. I teach Excel and on rare
occassion Excel simply does not work in this regard. I have the student move
to another machine and do the same thing with the same Excel sheet and it
works! Seems to be a myster to me

Previous Posts In This Thread:

On Saturday, September 19, 2009 6:24 PM
mustbesimple wrote:

I can't select non adjacent cells using the control button
For some reason I am having a terrible time selecting or highlighting a group
of cells and then using the control button and selecting another group of
cells

On Saturday, September 19, 2009 6:49 PM
Gord Dibben wrote:

Are you selecting say A1:A3 then hold CTRL key and select D1:D3?
Are you selecting say A1:A3 then hold CTRL key and select D1:D3?

What occurs when you try?

How about hitting SHIFT + F8 then selecting A1:A3 and D1:D3?


Gord Dibben MS Excel MVP

On Thursday, October 08, 2009 2:31 PM
KjenkinJC wrote:

I would really like to see an answer on this.
I would really like to see an answer on this. I teach Excel and on rare
occassion Excel simply does not work in this regard. I have the student move
to another machine and do the same thing with the same Excel sheet and it
works! Seems to be a myster to me

EggHeadCafe - Software Developer Portal of Choice
Silverlight 3 WCF-Enabled CodeSnippet app with Amazon SimpleDb
http://www.eggheadcafe.com/tutorials...cfenabled.aspx

Control key
 

I can select non-adjacent cells in Excel 2003 using the control key and the mouse. I cannot do this in my 2007 version of excel. This is extremely exasperating. Any ideas?



KjenkinJC wrote:

I would really like to see an answer on this.
08-Oct-09

I would really like to see an answer on this. I teach Excel and on rare
occassion Excel simply does not work in this regard. I have the student move
to another machine and do the same thing with the same Excel sheet and it
works! Seems to be a myster to me

Previous Posts In This Thread:

On Saturday, September 19, 2009 6:24 PM
mustbesimple wrote:

I can't select non adjacent cells using the control button
For some reason I am having a terrible time selecting or highlighting a group
of cells and then using the control button and selecting another group of
cells

On Saturday, September 19, 2009 6:49 PM
Gord Dibben wrote:

Are you selecting say A1:A3 then hold CTRL key and select D1:D3?
Are you selecting say A1:A3 then hold CTRL key and select D1:D3?

What occurs when you try?

How about hitting SHIFT + F8 then selecting A1:A3 and D1:D3?


Gord Dibben MS Excel MVP

On Thursday, October 08, 2009 2:31 PM
KjenkinJC wrote:

I would really like to see an answer on this.
I would really like to see an answer on this. I teach Excel and on rare
occassion Excel simply does not work in this regard. I have the student move
to another machine and do the same thing with the same Excel sheet and it
works! Seems to be a myster to me

On Friday, November 06, 2009 8:33 AM
Maurice Griswold wrote:

Control Key
I am experiencing the same problem. My 2003 version is fine. It is strictly limited to my 2007 version...anyone help?

EggHeadCafe - Software Developer Portal of Choice
Getting Better Information on Unhandled Exceptions In Managed Code
http://www.eggheadcafe.com/tutorials...nformatio.aspx

Control key
 

The CTRL key works just fine in XL2007, as it did in XL2003. Perhaps
you just can't see the selected cells (the color is very light and
very difficult to see if there is some background color applied to a
cell).

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Fri, 06 Nov 2009 05:35:39 -0800, Maurice Griswold wrote:

I can select non-adjacent cells in Excel 2003 using the control key and the mouse. I cannot do this in my 2007 version of excel. This is extremely exasperating. Any ideas?



KjenkinJC wrote:

I would really like to see an answer on this.
08-Oct-09

I would really like to see an answer on this. I teach Excel and on rare
occassion Excel simply does not work in this regard. I have the student move
to another machine and do the same thing with the same Excel sheet and it
works! Seems to be a myster to me

Previous Posts In This Thread:

On Saturday, September 19, 2009 6:24 PM
mustbesimple wrote:

I can't select non adjacent cells using the control button
For some reason I am having a terrible time selecting or highlighting a group
of cells and then using the control button and selecting another group of
cells

On Saturday, September 19, 2009 6:49 PM
Gord Dibben wrote:

Are you selecting say A1:A3 then hold CTRL key and select D1:D3?
Are you selecting say A1:A3 then hold CTRL key and select D1:D3?

What occurs when you try?

How about hitting SHIFT + F8 then selecting A1:A3 and D1:D3?


Gord Dibben MS Excel MVP

On Thursday, October 08, 2009 2:31 PM
KjenkinJC wrote:

I would really like to see an answer on this.
I would really like to see an answer on this. I teach Excel and on rare
occassion Excel simply does not work in this regard. I have the student move
to another machine and do the same thing with the same Excel sheet and it
works! Seems to be a myster to me

On Friday, November 06, 2009 8:33 AM
Maurice Griswold wrote:

Control Key
I am experiencing the same problem. My 2003 version is fine. It is strictly limited to my 2007 version...anyone help?

EggHeadCafe - Software Developer Portal of Choice
Getting Better Information on Unhandled Exceptions In Managed Code
http://www.eggheadcafe.com/tutorials...nformatio.aspx