trying to select multiple cells

M

marrie

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.
 
S

SteveW

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
 
R

Ragdyer

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
 
M

marrie

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.
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
 
M

marrie

thanks. I got it to work after trying a few times.
Should do
select a5
F8
F5
enter c10
click ok
works for me.

Steve
 
S

SteveW

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
 
M

marrie

cool. I'll keep this in mind. Thanks.
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top