selecting non adjacent cells

[fran]

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 ?

 

[JulieD]

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?

 

[Gord Dibben]

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

 

[fran]

Thanks JulieD + Gord I followed both of your ideas sadly neither worked not
to worry there's a solution somewhere .

 

[Gord Dibben]

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