Wednesday, May 27, 2009

Excel: Custom Sorting

1. Create your list in Excel. If possible include a header row for easy identification while sorting.
2. Highlight the information you need to sort.
3. Click on the Sort & Filter button found on the Home Ribbon.
4. Select Custom Sorting
5. The Sort pop-up box will appear. Select the column you need to sort information by: Last Name, Address, etc… If your column headers do not appear as options for sorting in the Sort by option, click on the box next to the My data has headers.
6. If you need to sort by more than one criterion, click on Add a Level and repeat above instructions.
7. Click on OK.
Additional sorting options include: Sort On which includes Cell color, Font color and Icon; Order which includes: A To Z; Z to A; and Custom List.

4 comments:

  1. I have always found this to be a very valuable feature on Excel!
    Patty

    ReplyDelete
  2. I found free career information on New York Colleges New York Schools, Best Careers in New York (NY) for various Programs like Medical Assisting Degree in New York (NY), College for Criminal Justice Career, Pharmacy Technician Degree NY, Business & Accounting Careers, Network Administration College Degree. So you can also visit.

    ReplyDelete
  3. Thank you for sharing. Recently I found College Information which offers both Associate of Occupational Studies and Associate in Applied Science degree programs. The programs of study are listed below, Business, Health Disciplines, Criminal Justice and Computer Technology. You can also Visit.

    ReplyDelete
  4. I found Insurance Agency which provides exceptional service with Personal and Business Insurance throughout North and Central New Jersey. You can also visit.

    ReplyDelete