[access-uk] Re: Sorting in Excel 2010
- From: "Griffiths, Steve" <Steve.Griffiths@xxxxxxxxxxx>
- To: <access-uk@xxxxxxxxxxxxx>
- Date: Tue, 28 May 2013 09:44:57 +0100
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==
dgZObCgFtlV1oBlBnXOWs0Q0dMbdr4tNS1kFoPzuIXnePg==> 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
Other related posts:
