when you have a lot of different rows in
your spreadsheet you may want to sort
the data so that you can view it more
easily sorting can reorder things
alphabetically numerically by date or
even by font color depending on your
preference you can either sort in the
Home tab from the sort and filter
drop-down menu or you can use the
commands in the data tab and these are
the ones that I'm going to be using
in this example I have a t-shirt order
form and I'd like to sort it by last
name just select any cell in the column
that you want to sort and then click the
ascending command and that's the one
that says AZ
you'll notice that when you sort the
column it also reorders all of the other
columns so that each row still has the
correct information
if we wanted these in reverse order we
could click the descending command
we can also sort it by homeroom which
sorts it numerically
or we could sort it by date
now what if we wanted to sort this by
t-shirt size
if I click on the ascending command the
order will be large medium small
extra-large because as ordering them
alphabetically it would be better if it
went small medium large extra-large and
for this we'll need to create a custom
sort
click the sort command and this opens a
dialog box and on the right you can see
that it's ordering from A to Z if you
click on that and select custom list
you'll be able to type in the t-shirt
sizes in the order that you want so I'll
type small medium large and x-large and
I'm pressing enter after each one and
then click Add
make sure that your list is selected
over here and then click OK
and now it's ordered the way that we
want
now the only problem with this is every
other column is completely out of order
now what I would really like is if the
home rooms were more organized within
each size I can do this by sorting
multiple levels and this will let us
sort first by t-shirt size and then by
homeroom
click the sort command
and we want to add a level
and then just select homeroom and then
we'll leave these the way they are
when you click OK you'll see that within
each t-shirt size the home rooms are in
numerical order
now if we wanted to sort by homeroom
first and then by t-shirt size we could
go back to the sort command
and then select one of these rows and
then use these arrows to change the
order
you
as you can see there are a lot of
different ways of sorting your data
depending on how you want to organize it
so take some time to experiment with the
different options to find the ones that
best suit your needs like what you just
saw rate it add a comment subscribe to
our Channel
the freedom to learn what you want when
you want absolutely free
GCF learn free.org