[access-uk] Re: Sorting in Excel 2010
- From: "Sharon Bowell" <sharon.bowell1@xxxxxxxxxxxxxx>
- To: <access-uk@xxxxxxxxxxxxx>
- Date: Tue, 28 May 2013 10:15:01 +0100
Many thanks Steve,
I'll be giving it a try later on.
I was not shift tabbing, to start with, which is probably why the thing
wouldn't work.
Thanks once again.
Sharon
From: access-uk-bounce@xxxxxxxxxxxxx [mailto:access-uk-bounce@xxxxxxxxxxxxx]
On Behalf Of Griffiths, Steve
Sent: 28 May 2013 09:45
To: access-uk@xxxxxxxxxxxxx
Subject: [access-uk] Re: Sorting in Excel 2010
Sharon,
Once you're in the data range you want to sort, it's Alt, H, S to open the
sort menu, then choose Custom Sort.
That will open a dialogue with your focus on the OK button. There are two
things to note with this dialogue:
1. You need to press Shift + Tab to get to the sort field and then Tab to
get into the first criterion - it's a weird one in that pressing Shift + Tab
followed by Tab doesn't put you back where you started.
2. As you Tab through the three fields for the sort criterion, you won't
hear all of the column headers. The first is the column you want to sort by,
the second is the value you want to sort by, and the third is the order.
JAWS only gives you part of this information, but it's enough for you to
work out which is which.
Once you've filled in the first criterion, Tab around to the Add Level
button and press it. You'll get no feedback that this has worked, but if you
then Tab to the sort field, you'll be on the second criterion. At this point
you can UpArrow to the first criterion if you want to change it, or Tab
through the second one and create it.
Hope that helps,
Steve
From: access-uk-bounce@xxxxxxxxxxxxx [mailto:access-uk-bounce@xxxxxxxxxxxxx]
On Behalf Of Sharon Bowell
Sent: 25 May 2013 12:32
To: access-uk@xxxxxxxxxxxxx
Subject: [access-uk] Sorting in Excel 2010
Hi,
Could someone kindly help me. I'm trying to sort a spread sheet in Excel
2010. I want column A to be sorted and then by column B.
I had this off to a fine art in Excel 2007 but for some reason can't work it
out in Excel 2010.
Could someone kindly help me out.
Thanks.
Sharon
Click here <https://www.mailcontrol.com/sr/MZbqvYs5QwJvpeaetUwhCQ==> to
report this email as spam.
--
For the first time, all our artefacts are open to the public for free in one
place. Find out more about RNIB Heritage Services' hidden gems:
http://rnib.in/17uWEWG
--
DISCLAIMER:
NOTICE: The information contained in this email and any attachments is
confidential and may be privileged. If you are not the intended recipient
you should not use, disclose, distribute or copy any of the content of it or
of any attachment; you are requested to notify the sender immediately of
your receipt of the email and then to delete it and any attachments from
your system.
RNIB endeavours to ensure that emails and any attachments generated by its
staff are free from viruses or other contaminants. However, it cannot
accept any responsibility for any such which are transmitted. We therefore
recommend you scan all attachments.
Please note that the statements and views expressed in this email and any
attachments are those of the author and do not necessarily represent those
of RNIB.
RNIB Registered Charity Number: 226227
Website: http://www.rnib.org.uk
This message has been scanned for viruses by Websense Hosted Security -
<http://www.websense.com/content/HostedEmailSecurity.aspx>
http://www.websense.com/content/HostedEmailSecurity.aspx
Other related posts:
