SELECT MORE THAN 1 ROW NOT NEXT TO EACH OTHER

[Ron de Bruin]

Hi Angel

You can hold the Ctrl key when you select the rows

 

[Angel]

Hi Angel

You can hold the Ctrl key when you select the rows

--
Regards Ron de Bruin
http://www.rondebruin.nl




thank you, but that was the frist thing i tried.

 

[Angel]

Hi Angel

You can hold the Ctrl key when you select the rows

 

[Angel]

thank you, but that is the 1st thing i tried

Hi Angel

You can hold the Ctrl key when you select the rows

 

[Dave Peterson]

And it didn't work for you?

What happened when you tried it?

 

[Gord Dibben]

And what occurred when you followed Ron's suggestion?

Try hitting SHIFT + F8 then select rows without holding the CTRL key.

What occurs with that method?


Gord Dibben MS Excel MVP

 

[Angel]

by using shift & f8 i can selct more than one row, but random rows.

 

[paul]

what is the selection requirent.You can select as many or as few rows
wherever thay are using crtl and click?

 

[Angel]

i'm not sure why but, crtl and click will not coy more the 1 row or line in
execel.

 

[paul]

thats strange i can select as many or as few as i wish.

 

[Angel]

would it help if i e-mailed or posted the worksheet ?

 

[paul]

is the sheet protected?

 

[Angel]

yes the sheet is protected.

is the sheet protected?