word-excel-access-help.com logo
Advanced Excel Sort
Home
Word 2007
Excel 2007
Access 2007
Word xp
Excel xp
Access xp

Advanced Excel Sort
Additional Resources



Advanced Excel Sort


Advanced Excel Sort

Advanced Excel Sort | Microsoft Excel XP | Page 2

Microsoft Excel XP logo
Learn step-by-step how to use the simple Excel sort and the Advanced Excel Sort.

Excel Office Helper What's on this page...
Simple Sort a List
Using a Custom Sort Order
Create a Custom List


Using a Custom Sort Order

Sorting is done either numerically or alphabetically, depending on the data.

In some cases, you may want to sort your data in other ways.

If your data consists of month names, you probably want them to appear in month order rather than alphabetically.

Excel, by default, has four custom lists, and you can define your own.

Excel Office Helper  To sort by a column list, click the Options button in the Sort dialog box.

Then select the list from the First key sort order drop-down list.


Excel custom lists are as follows:

ABBREVIATED DAYS
Sun, Mon, Tue, Wed, Thu, Fri, Sat.
   
►  DAYS
Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday.
   
ABBREVIATED MONTHS
Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec.
   
MONTHS
January, February, March, April, May, June, July, August, September, October, November, December.


Create a Custom List

You can, however, create your own custom sort list for Excel to use in your Advanced Excel sort.

To create a custom list, follow these steps:

1.  Choose Tools ► Options from the menu bar.
   
2.  In the Options dialog box, click the Custom Lists tab.
   
  Advanced Excel Sort: Custom Lists dialog box
   
3. Click the NEW LIST option from the Custom lists options.
   
4. Enter your list in the List Entries box, separated by commas.
   
5. Click the Add button.
   
6. Click OK.
 
Back to Top
 
See also... Simple Sort a List
 
Return to Excel XP from Advanced Excel Sort
 
Excel XP Topics
- Tips
- Excel Screen Layout
- Navigational Techniques
- Working with Workbooks
- Templates
- Working with Worksheets
- Moving Around
- Move Worksheets
- Copy Worksheets
- Insert & Delete Cells
- Insert & Delete Rows
- Insert & Delete Columns
- Resize Row
- Resize Column
- Editing Data
- Content Color
- Cell Color
- Number Formats
- Fonts
- Alignment
- Text Direction
- Indent Contents
- Merge Cells
- Copy
- Move
- Undo & Redo
- Using Zoom
- Freeze & Unfreeze Titles
- Split Worksheet
- Spreadsheet Data
- AutoFill
- AutoComplete
- Comment
- Find
- Replace
- Spellcheck
- Formulas
- Functions
- Print
- Password
- Sorting
- AutoFilter
- Advanced Filter
- Macros
- Charts
- Charting
- Charting Elements
- Gantt Chart
- PivotTable
- PivotTable Calculations
- PivotTable Layout
- PivotTable Format
- PDF to Excel
- PDF-to-Excel Converter
- Excel to PDF Converter