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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |