Freedom scientific a Vispero brand to use the sort feature in Excel.
The first step is to select the data you would like to have sorted for
the I'm using an Excel worksheet that reports students sat exam scores.
I have column.
Such as students' last and first names, their scores.
And then what grade they're in as reported by freshmen,
sophomore, junior, and senior.
So I'm going to go ahead and move to the data region that
I would like to have selected.
Now there are several ways to select data.
I'm going to use the go-to dialog box feature of Excel, which
quickly will select all the cells I would like to select.
We'll go ahead and press control G to open the go-to dialog box control D
reference edit reference, edit combo.
And now I'll need to insert the beginning data point, which in this
case is sell a four and the ending data point, which is sell F 25 or
Foxtrot 25, separated by a colon, which in Excel is like saying through.
So I'll go ahead and press A four.
And colon . And then my ending point of F 25 F two five.
I'll go ahead and press enter.
The dialogue box will close and cells a four through F 25 will be selected
Next you'll want to open your context menu.
You can open the context menu by pressing shift plus F 10,
or using the applications key.
I'm going to use the applications key and now the down arrow
key to find the sort option.
Copy C paste, special.dot dot unavailable S smart lookup.
Insert.dot dot I delete.dot dot D clear contents translate quick analysis,
filters sub menu, sort submenu sort.
JAWS reports that we are at the sort option.
And there's also a sub menu.
You can open a sub menu by either pressing the enter key
or pressing the right arrow key.
I'm going to press the right arrow key and the sub menu is
opened with all available options.
I'll go ahead and press the down arrow key so we can
see what's available to us.
Put selected cell color on top C put selected font color on top F
put selected formatting icon on top custom sort...you sort a to Z, S.
Once I got to the bottom of the list with an additional press of the
down arrow key, I was returned to the top of the list and the first
option, which was sort A to Z.
For this demonstration what makes the most sense is I would like to organize
these students' names alphabetically I'll go ahead and press enter.
And the sub menu will close and our data will be sorted alphabetically,
enter, leaving menus, selected range A4 F twenty-five sophomore.
I'll verify that the names are arranged alphabetically by pressing
my down arrow key a few times.
And it would appear that they are arranged alphabetically.
And that is how you use the sort feature in Excel.
To use the filter feature in Excel.
The first step is to move to a cell which contains information
that you would like to filter by for this demonstration.
I would like to sort my data by grade.
So I'm going to move to the grade column in the worksheet.
And I would like to see the scores only at the students who are a senior.
So I'm now going to look for a cell which reports the word senior.
Sophomore, F4 senior F 5.
Now that we've done that I'm going to open the context menu.
You can open the context menu by pressing shift plus F 10,
or using the applications key.
I'm going to use the applications key.
Applications, menu.
And now down arrow.
Key to find the filter option.
Copy C paste special...
unavailable S smart lookup, insert..., or delete...
clear contents and translate quick analysis filters sub menu filter E.
This filter option is a sub menu.
And to open a sub menu, you'll press the enter key or the right arrow key.
I'm going to press the right arrow key.
Clear filter unavailable.
And now we'll use the down arrow key so we can see what's available to us.
In this submenu.
Reapply unavailable R filtered by selected sales value V
filter by selected sales color C filter by selected sales font,
color filter by selected sales icon, clear filter unavailable.
Once we arrived at the last option in the sub menu, another press of
the down arrow key, moved us back to the top and beginning of the
list for this demonstration, I would like to filter the data using
the filter by the cells value.
reapply unavailable R filtered by selected sales value V.
So now that I've arrived at the filter by selected cell
value, I'm going to press enter.
The sub menu will close, and once I press enter, the sub menu will
close and I'll be returned back to the worksheet where only rows that
display the word senior will appear.
I'll go ahead and do that now.
Enter leaving menus, senior, F5.
adjacent to hidden cells.
And I'm going to, use my down arrow key to verify that
only seniors are being shown.
Senior.
F9 senior F 10 senior F 13, adjacent to hidden cells.
And that is you use the filter feature in Excel to clear filters, which you've
applied in Excel move to the selected cells value cell in this demonstration
of course it was the word senior so I'll go ahead and
move to a cell that says senior.
Senior, F 10, adjacent to hidden cells.
Then open the context menu, which you can open by pressing shift plus
F 10, or using the applications key.
I'll go ahead and use the applications.
Key applications, menu.
I'll press the down arrow to move to the filter option.
Copy C paste, special...unavailable S smart lookup insert row delete
row clear contents translate, quick analysis filters submenu filter E.
Open this sub menu by pressing the right arrow key clear filter from grade, E.
And the very first option advises us that we can clear this filter.
I'm going to press enter.
And now as I press my up and down arrow keys, I should hear results that contain
other grades as well as senior junior, F 11 junior F 12, senior sophomore, F 14.
And that is how you clear a filter in the filter feature freedom
scientific a Vispero brand to stay up to date on upcoming webinars and
training events complete the up form at freedomscientific.com/webinars
thanks again for connecting with us.