|
| 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. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 22nd, 2004, 06:25 PM
|
|||
|
|||
Cell selection - unselect
When using the control key to select several ranges of cells, is there a way
to unselect some of the cells previously selected? Thanks 
|
|
#2
July 22nd, 2004, 06:35 PM
|
|||
|
|||
|
Cell selection - unselect
Hi
hold down the CTRL key whild de-selecting these cells -- Regards Frank Kabel Frankfurt, Germany "uberlib" schrieb im Newsbeitrag ... When using the control key to select several ranges of cells, is there a way to unselect some of the cells previously selected? Thanks
|
|
#3
July 22nd, 2004, 07:17 PM
|
|||
|
|||
|
Cell selection - unselect
When using the control key to select several ranges of cells, is
there a way to unselect some of the cells previously selected? Thanks "Frank Kabel" wrote in message ... Hi hold down the CTRL key whild de-selecting these cells -- Regards Frank Kabel Frankfurt, Germany I must be missing something here. While holding down the CTRL key, I can only select more cells. (excel 2000). If I hold the Shift key down in addition to CTRL, it de-selects all the previously selected cells (when I left click).
|
|
#4
July 22nd, 2004, 08:02 PM
|
|||
|
|||
|
Cell selection - unselect
Frank!
You're slipping! Get some sleep!g -- Jim Rech Excel MVP "Frank Kabel" wrote in message ... | Hi | hold down the CTRL key whild de-selecting these cells | | -- | Regards | Frank Kabel | Frankfurt, Germany | | "uberlib" schrieb im Newsbeitrag | ... | When using the control key to select several ranges of cells, is | there a way | to unselect some of the cells previously selected? | Thanks | | |
|
|
#5
July 22nd, 2004, 08:15 PM
|
|||
|
|||
|
Cell selection - unselect
Hi Jim
it's not that late. Don't know how i came to this idea. Think it was a different program with this kind of behaviour??? -- Regards Frank Kabel Frankfurt, Germany "Jim Rech" schrieb im Newsbeitrag ... Frank! You're slipping! Get some sleep!g -- Jim Rech Excel MVP "Frank Kabel" wrote in message ... | Hi | hold down the CTRL key whild de-selecting these cells | | -- | Regards | Frank Kabel | Frankfurt, Germany | | "uberlib" schrieb im Newsbeitrag | ... | When using the control key to select several ranges of cells, is | there a way | to unselect some of the cells previously selected? | Thanks | | |
|
|
#6
July 23rd, 2004, 12:37 AM
|
|||
|
|||
|
Cell selection - unselect
uber
Not possible without some VBA coding. See this google search thread for some code from Chip Pearson. http://www.google.com/groups?threadm...GP10.p hx.gbl If not familiar with VBA and macros, see David MCRritchie's :getting started" pages. http://www.mvps.org/dmcritchie/excel/getstarted.htm Gord Dibben Excel MVP On Thu, 22 Jul 2004 17:25:34 GMT, "uberlib" wrote: When using the control key to select several ranges of cells, is there a way to unselect some of the cells previously selected? Thanks
|
|
#7
July 23rd, 2004, 02:29 AM
|
|||
|
|||
|
Cell selection - unselect
Windows explorer (and other "nice" programs!)
Frank Kabel wrote: Hi Jim it's not that late. Don't know how i came to this idea. Think it was a different program with this kind of behaviour??? -- Regards Frank Kabel Frankfurt, Germany "Jim Rech" schrieb im Newsbeitrag ... Frank! You're slipping! Get some sleep!g -- Jim Rech Excel MVP "Frank Kabel" wrote in message ... | Hi | hold down the CTRL key whild de-selecting these cells | | -- | Regards | Frank Kabel | Frankfurt, Germany | | "uberlib" schrieb im Newsbeitrag | ... | When using the control key to select several ranges of cells, is | there a way | to unselect some of the cells previously selected? | Thanks | | | -- Dave Peterson
|
|
#8
July 23rd, 2004, 04:31 AM
|
|||
|
|||
|
Cell selection - unselect
Hi Dave
no in this case it was more a custome developed ledger application for an investment bank :-))) -- Regards Frank Kabel Frankfurt, Germany "Dave Peterson" schrieb im Newsbeitrag ... Windows explorer (and other "nice" programs!) Frank Kabel wrote: Hi Jim it's not that late. Don't know how i came to this idea. Think it was a different program with this kind of behaviour??? -- Regards Frank Kabel Frankfurt, Germany "Jim Rech" schrieb im Newsbeitrag ... Frank! You're slipping! Get some sleep!g -- Jim Rech Excel MVP "Frank Kabel" wrote in message ... | Hi | hold down the CTRL key whild de-selecting these cells | | -- | Regards | Frank Kabel | Frankfurt, Germany | | "uberlib" schrieb im Newsbeitrag | ... | When using the control key to select several ranges of cells, is | there a way | to unselect some of the cells previously selected? | Thanks | | | -- Dave Peterson
|
|
#9
July 23rd, 2004, 12:08 PM
|
|||
|
|||
|
Cell selection - unselect
Thanks,
I'll save the link for when I have a little more time. "Gord Dibben" gorddibbATshawDOTca wrote in message ... uber Not possible without some VBA coding. See this google search thread for some code from Chip Pearson. http://www.google.com/groups?threadm...GP10.p hx.gbl If not familiar with VBA and macros, see David MCRritchie's :getting started" pages. http://www.mvps.org/dmcritchie/excel/getstarted.htm Gord Dibben Excel MVP On Thu, 22 Jul 2004 17:25:34 GMT, "uberlib" wrote: When using the control key to select several ranges of cells, is there a way to unselect some of the cells previously selected? Thanks
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Turn Off Multiple Cell Selection | Anna | General Discussion | 3 | July 12th, 2004 11:02 PM |
| Calculations based on cell selection | Shaun | Worksheet Functions | 3 | March 16th, 2004 05:39 PM |
| How do do Concatenated Cell Values | Steve Arndt | Worksheet Functions | 3 | January 21st, 2004 05:34 PM |
| Formula help | Wally | Worksheet Functions | 6 | December 5th, 2003 12:18 PM |
| Cell reference data not displaying in chart | Jon Peltier | Charts and Charting | 0 | November 12th, 2003 06:30 PM |
Linear Mode
