ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   SELECT MORE THAN 1 ROW NOT NEXT TO EACH OTHER (https://www.excelbanter.com/excel-worksheet-functions/102073-select-more-than-1-row-not-next-each-other.html)

Angel

SELECT MORE THAN 1 ROW NOT NEXT TO EACH OTHER
 


Ron de Bruin

SELECT MORE THAN 1 ROW NOT NEXT TO EACH OTHER
 
Hi Angel

You can hold the Ctrl key when you select the rows

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



"Angel" wrote in message ...




Angel

SELECT MORE THAN 1 ROW NOT NEXT TO EACH OTHER
 


"Ron de Bruin" wrote:

Hi Angel

You can hold the Ctrl key when you select the rows

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



"Angel" wrote in message ...

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



Angel

SELECT MORE THAN 1 ROW NOT NEXT TO EACH OTHER
 

"Ron de Bruin" wrote:

Hi Angel

You can hold the Ctrl key when you select the rows

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



"Angel" wrote in message ...





Angel

SELECT MORE THAN 1 ROW NOT NEXT TO EACH OTHER
 
thank you, but that is the 1st thing i tried

"Ron de Bruin" wrote:

Hi Angel

You can hold the Ctrl key when you select the rows

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



"Angel" wrote in message ...





Dave Peterson

SELECT MORE THAN 1 ROW NOT NEXT TO EACH OTHER
 
And it didn't work for you?

What happened when you tried it?

Angel wrote:

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

"Ron de Bruin" wrote:

Hi Angel

You can hold the Ctrl key when you select the rows

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



"Angel" wrote in message ...





--

Dave Peterson

Gord Dibben

SELECT MORE THAN 1 ROW NOT NEXT TO EACH OTHER
 
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



On Sat, 29 Jul 2006 15:45:01 -0700, Angel
wrote:



"Ron de Bruin" wrote:

Hi Angel

You can hold the Ctrl key when you select the rows

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



"Angel" wrote in message ...

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




Angel

SELECT MORE THAN 1 ROW NOT NEXT TO EACH OTHER
 
by using shift & f8 i can selct more than one row, but random rows.

"Dave Peterson" wrote:

And it didn't work for you?

What happened when you tried it?

Angel wrote:

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

"Ron de Bruin" wrote:

Hi Angel

You can hold the Ctrl key when you select the rows

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



"Angel" wrote in message ...





--

Dave Peterson


paul

SELECT MORE THAN 1 ROW NOT NEXT TO EACH OTHER
 
what is the selection requirent.You can select as many or as few rows
wherever thay are using crtl and click?
--
paul

remove nospam for email addy!



"Angel" wrote:

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

"Dave Peterson" wrote:

And it didn't work for you?

What happened when you tried it?

Angel wrote:

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

"Ron de Bruin" wrote:

Hi Angel

You can hold the Ctrl key when you select the rows

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



"Angel" wrote in message ...





--

Dave Peterson


Angel

SELECT MORE THAN 1 ROW NOT NEXT TO EACH OTHER
 
i'm not sure why but, crtl and click will not coy more the 1 row or line in
execel.

"paul" wrote:

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

remove nospam for email addy!



"Angel" wrote:

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

"Dave Peterson" wrote:

And it didn't work for you?

What happened when you tried it?

Angel wrote:

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

"Ron de Bruin" wrote:

Hi Angel

You can hold the Ctrl key when you select the rows

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



"Angel" wrote in message ...





--

Dave Peterson


paul

SELECT MORE THAN 1 ROW NOT NEXT TO EACH OTHER
 
thats strange i can select as many or as few as i wish.
--
paul

remove nospam for email addy!



"Angel" wrote:

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

"paul" wrote:

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

remove nospam for email addy!



"Angel" wrote:

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

"Dave Peterson" wrote:

And it didn't work for you?

What happened when you tried it?

Angel wrote:

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

"Ron de Bruin" wrote:

Hi Angel

You can hold the Ctrl key when you select the rows

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



"Angel" wrote in message ...





--

Dave Peterson


Angel

SELECT MORE THAN 1 ROW NOT NEXT TO EACH OTHER
 
would it help if i e-mailed or posted the worksheet ?

"paul" wrote:

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

remove nospam for email addy!



"Angel" wrote:

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

"paul" wrote:

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

remove nospam for email addy!



"Angel" wrote:

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

"Dave Peterson" wrote:

And it didn't work for you?

What happened when you tried it?

Angel wrote:

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

"Ron de Bruin" wrote:

Hi Angel

You can hold the Ctrl key when you select the rows

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



"Angel" wrote in message ...





--

Dave Peterson


paul

SELECT MORE THAN 1 ROW NOT NEXT TO EACH OTHER
 
is the sheet protected?
--
paul

remove nospam for email addy!



"Angel" wrote:

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

"paul" wrote:

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

remove nospam for email addy!



"Angel" wrote:

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

"paul" wrote:

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

remove nospam for email addy!



"Angel" wrote:

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

"Dave Peterson" wrote:

And it didn't work for you?

What happened when you tried it?

Angel wrote:

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

"Ron de Bruin" wrote:

Hi Angel

You can hold the Ctrl key when you select the rows

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



"Angel" wrote in message ...





--

Dave Peterson


Angel

SELECT MORE THAN 1 ROW NOT NEXT TO EACH OTHER
 
yes the sheet is protected.

"paul" wrote:

is the sheet protected?
--
paul

remove nospam for email addy!



"Angel" wrote:

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

"paul" wrote:

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

remove nospam for email addy!



"Angel" wrote:

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

"paul" wrote:

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

remove nospam for email addy!



"Angel" wrote:

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

"Dave Peterson" wrote:

And it didn't work for you?

What happened when you tried it?

Angel wrote:

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

"Ron de Bruin" wrote:

Hi Angel

You can hold the Ctrl key when you select the rows

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



"Angel" wrote in message ...





--

Dave Peterson



All times are GMT +1. The time now is 06:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com