|
Recording names and student numbers can be a full-time job.
Just as soon as you have everyone in the correct order, you have a new student
whose last name starts with the letter C. With Excel 2000, sorting the names by
last name, or any other order, is quick and easy. Using Excel 2000, you can
track information for each student, and then organize it according to
importance or category.
TO ALPHABETIZE NAMES
1.
Open the Attendance worksheet if it is not already open.
2.
Select cells
A4 through the end of the list in column B
so that all names and student numbers are selected.
3.
On the
Data
menu, click Sort.
4.
Under
Sort by,
select Column
A and
then click Ascending.
5.
Click
OK.
6.
On the
File menu, click
Save.
|