ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   trying to select multiple cells (https://www.excelbanter.com/new-users-excel/109256-trying-select-multiple-cells.html)

marrie

trying to select multiple cells
 
Hello. I can't remember how to select multiple cells in this worksheet.
example I want to select a1 to i11 or something. I need to use the keyboard
for this as I am visually impaired and cannot use a mouse. Thanks.



SteveW

trying to select multiple cells
 
Select first cell, then Hold Shift while move select cell to the other
corner cell

Or you can use F8 as follows
Select first cell, then press F8 now movement of the selected cell will
produce a select area.

To produce multiple blocks
Shift F8 will keep the selected area, now move to another area, Shift F8
to start a new block

Steve


On Sun, 10 Sep 2006 04:45:01 +0100, marrie wrote:

Hello. I can't remember how to select multiple cells in this worksheet..
example I want to select a1 to i11 or something. I need to use the
keyboard
for this as I am visually impaired and cannot use a mouse. Thanks.



RagDyeR

trying to select multiple cells
 
Try this:
<Ctrl <Home
to get to A1,
Hold <Shift and hit <Down Arrow
to get to Row11
Then, *still* holding <Shift
<Right Arrow to get to Column I
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"marrie" wrote in message
...
Hello. I can't remember how to select multiple cells in this worksheet.
example I want to select a1 to i11 or something. I need to use the

keyboard
for this as I am visually impaired and cannot use a mouse. Thanks.




marrie

trying to select multiple cells
 
I thought f8 then f5 and type the cell youwanted to go to and that would
iselectt. but it didn't work for some reason.
"SteveW" wrote in message
news:op.tfm9k1y3evjsnp@enigma03...
Select first cell, then Hold Shift while move select cell to the other
corner cell

Or you can use F8 as follows
Select first cell, then press F8 now movement of the selected cell will
produce a select area.

To produce multiple blocks
Shift F8 will keep the selected area, now move to another area, Shift F8
to start a new block

Steve


On Sun, 10 Sep 2006 04:45:01 +0100, marrie wrote:

Hello. I can't remember how to select multiple cells in this worksheet.
example I want to select a1 to i11 or something. I need to use the
keyboard
for this as I am visually impaired and cannot use a mouse. Thanks.





SteveW

trying to select multiple cells
 
Should do
select a5
F8
F5
enter c10
click ok
works for me.

Steve

On Sun, 10 Sep 2006 08:16:39 +0100, marrie wrote:

I thought f8 then f5 and type the cell youwanted to go to and that would
iselectt. but it didn't work for some reason.
"SteveW" wrote in message
news:op.tfm9k1y3evjsnp@enigma03...
Select first cell, then Hold Shift while move select cell to the other
corner cell

Or you can use F8 as follows
Select first cell, then press F8 now movement of the selected cell will
produce a select area.

To produce multiple blocks
Shift F8 will keep the selected area, now move to another area, Shift F8
to start a new block

Steve


On Sun, 10 Sep 2006 04:45:01 +0100, marrie wrote:

Hello. I can't remember how to select multiple cells in this worksheet.


marrie

trying to select multiple cells
 
thanks. I got it to work after trying a few times.
"SteveW" wrote in message
news:op.tfnjfpwaevjsnp@enigma03...
Should do
select a5
F8
F5
enter c10
click ok
works for me.

Steve

On Sun, 10 Sep 2006 08:16:39 +0100, marrie wrote:

I thought f8 then f5 and type the cell youwanted to go to and that would
iselectt. but it didn't work for some reason.
"SteveW" wrote in message
news:op.tfm9k1y3evjsnp@enigma03...
Select first cell, then Hold Shift while move select cell to the other
corner cell

Or you can use F8 as follows
Select first cell, then press F8 now movement of the selected cell will
produce a select area.

To produce multiple blocks
Shift F8 will keep the selected area, now move to another area, Shift F8
to start a new block

Steve


On Sun, 10 Sep 2006 04:45:01 +0100, marrie wrote:

Hello. I can't remember how to select multiple cells in this worksheet.
example I want to select a1 to i11 or something. I need to use the
keyboard
for this as I am visually impaired and cannot use a mouse. Thanks.




SteveW

trying to select multiple cells
 
Glad it worked.

Remember after one block, Shift F8 will let you move, keping the first
block selected.

andogther Shift F8 will start the next block
Steve

On Mon, 11 Sep 2006 04:42:27 +0100, marrie wrote:

thanks. I got it to work after trying a few times.
"SteveW" wrote in message
news:op.tfnjfpwaevjsnp@enigma03...
Should do
select a5
F8
F5
enter c10
click ok
works for me.

Steve

On Sun, 10 Sep 2006 08:16:39 +0100, marrie wrote:

I thought f8 then f5 and type the cell youwanted to go to and that would
iselectt. but it didn't work for some reason.
"SteveW" wrote in message
news:op.tfm9k1y3evjsnp@enigma03...
Select first cell, then Hold Shift while move select cell to the other
corner cell

Or you can use F8 as follows
Select first cell, then press F8 now movement of the selected cell will
produce a select area.

To produce multiple blocks
Shift F8 will keep the selected area, now move to another area, Shift F8
to start a new block

Steve


On Sun, 10 Sep 2006 04:45:01 +0100, marrie wrote:

Hello. I can't remember how to select multiple cells in this worksheet.
example I want to select a1 to i11 or something. I need to use the
keyboard
for this as I am visually impaired and cannot use a mouse. Thanks.



marrie

trying to select multiple cells
 
cool. I'll keep this in mind. Thanks.
"SteveW" wrote in message
news:op.tfpimjrkevjsnp@enigma03...
Glad it worked.

Remember after one block, Shift F8 will let you move, keping the first
block selected.

andogther Shift F8 will start the next block
Steve

On Mon, 11 Sep 2006 04:42:27 +0100, marrie wrote:

thanks. I got it to work after trying a few times.
"SteveW" wrote in message
news:op.tfnjfpwaevjsnp@enigma03...
Should do
select a5
F8
F5
enter c10
click ok
works for me.

Steve

On Sun, 10 Sep 2006 08:16:39 +0100, marrie wrote:

I thought f8 then f5 and type the cell youwanted to go to and that would
iselectt. but it didn't work for some reason.
"SteveW" wrote in message
news:op.tfm9k1y3evjsnp@enigma03...
Select first cell, then Hold Shift while move select cell to the other
corner cell

Or you can use F8 as follows
Select first cell, then press F8 now movement of the selected cell will
produce a select area.

To produce multiple blocks
Shift F8 will keep the selected area, now move to another area, Shift F8
to start a new block

Steve


On Sun, 10 Sep 2006 04:45:01 +0100, marrie wrote:

Hello. I can't remember how to select multiple cells in this worksheet.
example I want to select a1 to i11 or something. I need to use the
keyboard
for this as I am visually impaired and cannot use a mouse. Thanks.






All times are GMT +1. The time now is 07:52 PM.

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