Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default 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
  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default 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
  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default 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


  #6   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 7,247
Default 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

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
Need to select non-adjacent cells with regular interval rickhoff Excel Discussion (Misc queries) 3 June 10th 13 10:18 AM
Select and move two NON-ADJACENT Excel cells simultaneously ? Vulture Excel Worksheet Functions 4 July 30th 09 07:12 PM
Control Select doesn't shade cells astanfo Excel Discussion (Misc queries) 0 May 30th 08 08:35 PM
Control + Shift + Up/Down not allowing me to select multiple cells. [email protected] Excel Discussion (Misc queries) 1 April 5th 07 02:31 PM
Select a range of non-adjacent cells in Excel? hodgsonk Excel Worksheet Functions 12 July 1st 06 04:34 AM


All times are GMT +1. The time now is 09:25 AM.

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

About Us

"It's about Microsoft Excel"