Re: selecting nonadjacent ranges in Excel
- From: Shanda Adkins <shanda.adkins@xxxxxxxxx>
- To: jfw@xxxxxxxxxxxxx
- Date: Tue, 11 Jan 2011 16:26:34 -0500
Hi, All,
Okay, Anne, then my syntax was wrong. I also figured out another
way to do it after much searching: Using the shift plus F8 command.
It's always good to know two ways to do things, but your way works
much quicker.
My text is asking me to cut the range and copy further down the
table thus giving some blank rows to insert more data. I could of
course just ad the rows, but since this is what the text is asking,
this is how I want to do it.
The problem now is when I tell Excel to cut the range I've selected,
it says my command cannot be performed with multiple selections.
Select only one range.
I know this can be performed by sighted people--that must be so, for
they're telling us to do this in this textbook. So... How should I
do this?
Thanks,
Shanda
On 1/11/11, Ann byrne <annakb@xxxxxxxxxxxxx> wrote:
> Shanda, if you put a comma between the ranges, go to works just fine.
> A1:A5,F1:G5
>
> At 02:07 PM 1/11/2011, you wrote:
>>Hello, all,
>> My name is Shanda, and I've been a JAWS user since sometime around
>>version 3.7--a bit before that release, but I can't pinpoint a date.
>>Most of what I know about JAWS, I taught myself--broke down and used a
>>couple of the basic training files a few weeks ago to deal with Office
>>2007 stuff.
>> Anyway, I'm running Windows XP Home on an Asus netbook with JAWS 12
>>and MS Office 2007 professional.
>> I have some limited experience with Excel, but I'm now in a computer
>>class which is entirely concerned with Excel 2007.
>> I need to know how to select a range of data when that range is, say,
>>A1:A5;F1:G5
>> I read some older messages that suggested using the Go To function
>>or F5, and that worked for selecting two rows of data but I couldn't
>>figure out how to get it to select the range I put above. Perhaps my
>>syntax is wrong...
>> any help would be appreciated.
>>Thanks so much,
>>Shanda
>>--
>>JFW related links:
>>JFW homepage: http://www.freedomscientific.com/
>>Scripting mailing list:
>>http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
>>JFW List instructions:
>>To post a message to the list, send it to jfw@xxxxxxxxxxxxx
>>To unsubscribe from this mailing list, send a message to
>>jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
>>Archives located at: //www.freelists.org/archives/jfw
>>Alternative archives located at:
>>http://n2.nabble.com/JAWS-for-Windows-f2145279.html
>>
>>If you have any concerns about the list, post received from the
>>list, or the way the list is being run, do not post them to the
>>list. Rather contact the list owner at jfw-admins@xxxxxxxxxxxxxx
>
> --
> JFW related links:
> JFW homepage: http://www.freedomscientific.com/
> Scripting mailing list:
> http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
> JFW List instructions:
> To post a message to the list, send it to jfw@xxxxxxxxxxxxx
> To unsubscribe from this mailing list, send a message to
> jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
> Archives located at: //www.freelists.org/archives/jfw
> Alternative archives located at:
> http://n2.nabble.com/JAWS-for-Windows-f2145279.html
>
> If you have any concerns about the list, post received from the list, or the
> way the list is being run, do not post them to the list. Rather contact the
> list owner at jfw-admins@xxxxxxxxxxxxxx
>
--
JFW related links:
JFW homepage: http://www.freedomscientific.com/
Scripting mailing list:
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //www.freelists.org/archives/jfw
Alternative archives located at:
http://n2.nabble.com/JAWS-for-Windows-f2145279.html
If you have any concerns about the list, post received from the list, or the
way the list is being run, do not post them to the list. Rather contact the
list owner at jfw-admins@xxxxxxxxxxxxxx
Other related posts:
