| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SELECT MORE THAN 1 ROW NOT NEXT TO EACH OTHER
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ... |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ... |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When creating a formula how do you select only visible cells | Excel Discussion (Misc queries) | |||
| Cannot select a chart on an Excel worksheet | Charts and Charting in Excel | |||
| Still can select locked cells in protected sheet | New Users to Excel | |||
| SELECT large amount of data in a worksheet | Excel Discussion (Misc queries) | |||
| Cells User Select Locked after upgrade to Excel 2002 | Excel Discussion (Misc queries) | |||
Linear Mode
