Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 9
Default 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.


  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 427
Default 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.


  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,572
Default 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.



  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 9
Default 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.




  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 427
Default 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.



  #6   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 9
Default 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.



  #7   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 427
Default 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.


  #8   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 9
Default 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.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
checking that cells have a value before the workbook will close kcdonaldson Excel Worksheet Functions 8 December 5th 05 04:57 PM
Still can select locked cells in protected sheet Andy New Users to Excel 11 October 29th 05 07:45 PM
select a range using "cells()" fullers Excel Worksheet Functions 2 July 6th 05 06:00 PM
requires that merged cells must be identically sized? Catt Excel Discussion (Misc queries) 11 July 3rd 05 12:36 PM
How can I have excel search and add multiple cells to find a targe Blakepro Excel Discussion (Misc queries) 1 April 1st 05 02:37 AM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"