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

  • Thread starter Thread starter mustbesimple
  • Start date Start date
M

mustbesimple

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
 
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
 
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
 
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 rar
occassion Excel simply does not work in this regard. I have the student mov
to another machine and do the same thing with the same Excel sheet and i
works! Seems to be a myster to me

Previous Posts In This Thread:

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

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

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 rar
occassion Excel simply does not work in this regard. I have the student mov
to another machine and do the same thing with the same Excel sheet and i
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/tutorial...0d-068142bff1a9/silverlight-3-wcfenabled.aspx
 
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 rar
occassion Excel simply does not work in this regard. I have the student mov
to another machine and do the same thing with the same Excel sheet and i
works! Seems to be a myster to me

Previous Posts In This Thread:

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

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

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 rar
occassion Excel simply does not work in this regard. I have the student mov
to another machine and do the same thing with the same Excel sheet and i
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?

EggHeadCafe - Software Developer Portal of Choice
Getting Better Information on Unhandled Exceptions In Managed Code
http://www.eggheadcafe.com/tutorial...f-5ff1e261144c/getting-better-informatio.aspx
 
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)
 
Back
Top