Re: Excel 2007 Sort?
- From: Alex Midence <alex.midence@xxxxxxxxx>
- To: jfw@xxxxxxxxxxxxx
- Date: Tue, 15 Jun 2010 08:40:39 -0500
Hmmh. Ok. There's two places you can find it depending on what kind
of keyboard you are using:
If it's a desktop keyboard, it's the key right next to the right
control key. It's on the same side of the keyboard as the enter key
is and and it's the first key to the left of that control button.
Make sense?
If you are using a laptop keyboard, it gets trickier. On my Dell,
it's above the f9 key right up against the screen.
Hope that helps. Oh, and, I'm at work now so I can tell you where on
the ribbon this key is in Excel if you can't find the application key.
It's in the Data tab of the ribbon. From where you are wanting to
sort, hit alt to activate the ribbon and then arrow right till you
hear Data Tab. Now, hit down arrow to take you into the menu and hit
the tab button until you get to the sort options.
Happy sorting,
Alex
On 6/15/10, Lisle, Ted (CHFS DMS) <Ted.Lisle@xxxxxx> wrote:
> Folks keep talking about the application key. Are you talking about
> Alt, right mouse button, what is the application key?
>
> Ted
>
> -----Original Message-----
> From: jfw-bounce@xxxxxxxxxxxxx [mailto:jfw-bounce@xxxxxxxxxxxxx] On
> Behalf Of Alex Midence
> Sent: Tuesday, June 15, 2010 12:16 AM
> To: jfw@xxxxxxxxxxxxx
> Subject: Re: Excel 2007 Sort?
>
> Try using the context menu that comes up in the application key. I
> think there's a sort submenu there.
>
> Thanks.
>
> Alex
>
>
>
> On 6/14/10, Ann Marie Medlar <amedlar1@xxxxxxxxx> wrote:
>> Thanks for link, I'll keep this in my save emial folder for future
>> reference. I cannot always remember key combos. On one PC I have
> Excel
>> 2003 which I think is easier to navigate but I guess I just need to
> learn
>> latest versions.
>> Thanks again,
>> Ann
>>
>> ----- Original Message -----
>> From: "Ann Byrne" <annakb@xxxxxxxxxxxxx>
>> To: <jfw@xxxxxxxxxxxxx>
>> Sent: Monday, June 14, 2010 1:35 PM
>> Subject: Re: Excel 2007 Sort?
>>
>>
>>> To sort a to z: h s s
>>> sort z to a: h s o
>>> custom sort: h s u
>>> The link to the set of tables I use is
>>>
>>> http://www.lboro.ac.uk/it/access/excel2007-key-tips.html
>>>
>>>
>>>
>>>
>>>
>>> At 11:41 AM 6/14/2010, you wrote:
>>>>Hi,
>>>>Cannot find the sort option in Excel 2007. What menu option is it
> under?
>>>>I wish to sort descending on column d then ascending on column e.
>>>>could someon give me quick key stroke?
>>>>
>>>
>>> --
>>> 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
> --
> 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:
