Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Still can select locked cells in protected sheet | New Users to Excel | |||
select a range using "cells()" | Excel Worksheet Functions | |||
requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
How can I have excel search and add multiple cells to find a targe | Excel Discussion (Misc queries) |