Home |
Search |
Today's Posts |
#1
|
|||
|
|||
selecting non adjacent cells
Can somebody help me? I am using XP home and I cannot select non adjacent
cells using the Ctrl button , does XP home have this function or am I just useless ? |
#2
|
|||
|
|||
Hi Fran
definitely not useless ... but yes, in Excel XP you should be able to select non adjacent cells using the control button - process is click on the first cell with the mouse hold down control key click on the next cell with mouse keep holding down control key click on other desired cells what happens when you follow these steps? -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "fran" wrote in message ... Can somebody help me? I am using XP home and I cannot select non adjacent cells using the Ctrl button , does XP home have this function or am I just useless ? |
#3
|
|||
|
|||
Fran
As an alternative to Julie's steps you can hit SHIFT + F8 to get into "ADD" mode. Just clicking on cells will select them without holding the CTRL key. When done selecting and doing whatever with the selection, hit F8 twice to get out of ADD mode. BTW.......XP Home is Windows Operating System, not Office or Excel. Your MS Office program will be Office XP(2002) or 97 or 2000 or 2003. Gord Dibben Excel MVP On Sun, 24 Apr 2005 22:53:35 +0800, "JulieD" wrote: definitely not useless ... but yes, in Excel XP you should be able to select non adjacent cells using the control button - process is click on the first cell with the mouse hold down control key click on the next cell with mouse keep holding down control key click on other desired cells what happens when you follow these steps? -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ...well i'm working on it anyway "fran" wrote in message ... Can somebody help me? I am using XP home and I cannot select non adjacent cells using the Ctrl button , does XP home have this function or am I just useless ? |
#4
|
|||
|
|||
Thanks JulieD + Gord I followed both of your ideas sadly neither worked not
to worry there's a solution somewhere . "JulieD" wrote: Hi Fran definitely not useless ... but yes, in Excel XP you should be able to select non adjacent cells using the control button - process is click on the first cell with the mouse hold down control key click on the next cell with mouse keep holding down control key click on other desired cells what happens when you follow these steps? -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "fran" wrote in message ... Can somebody help me? I am using XP home and I cannot select non adjacent cells using the Ctrl button , does XP home have this function or am I just useless ? |
#5
|
|||
|
|||
Fran
Is sheet protection enabled and "select locked cells" disabled? Or similar scenario. What happens when you try to select non-adjacent cells? What happens when you try to select adjacent cells? Gord On Sun, 24 Apr 2005 11:50:06 -0700, "fran" wrote: Thanks JulieD + Gord I followed both of your ideas sadly neither worked not to worry there's a solution somewhere . "JulieD" wrote: Hi Fran definitely not useless ... but yes, in Excel XP you should be able to select non adjacent cells using the control button - process is click on the first cell with the mouse hold down control key click on the next cell with mouse keep holding down control key click on other desired cells what happens when you follow these steps? -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "fran" wrote in message ... Can somebody help me? I am using XP home and I cannot select non adjacent cells using the Ctrl button , does XP home have this function or am I just useless ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop text displaying in blank adjacent cells? | Excel Discussion (Misc queries) | |||
Selecting cells using shortcut keys not mouse | Excel Discussion (Misc queries) | |||
selecting multiple cells with ctrl key | Charts and Charting in Excel | |||
Excel 97 - Selecting multiple cells from 2 different Pivot Tables | Excel Discussion (Misc queries) | |||
Selecting shaded cells in a row | Excel Worksheet Functions |