With built-in custom lists, you can sort data—either by days of the week or months of the year. Optionally, you can create your own custom lists to sort by any other characteristic that doesn’t sort well alphabetically—such as high, medium, and low—or S, M, L, XL.
Sep 13, 2018 - Pada tutorial cara menggunakan Record Macro ini kita akan mempelajari cara merekam kegiatan yang kita kerjakan pada Microsoft Excel. Oct 30, 2016 CARA MUDAH MENGGUNAKAN MICROSOFT EXCEL. 9.Create 6 step ROUNDED RECTANGULAR infograhic/PowerPoint Presentation/Graphic Design/Free Template - Duration: 6:12. PowerUP with POWERPOINT. 5 days ago - Cara Dan Contoh Membuat Pembukuan Sederhana Dengan Ms. Membuat Pembukuan Sederhana Menggunakan Ms.
With custom lists, you could sort this worksheet either by Delivery month or by Priority.
Follow these steps:
Select the columns to sort.
Note: For the best results, each column should have a heading.
In the ribbon, click Data > Sort.
In the Sort popup window, in the Sort by drop-down, choose the column on which you need to sort.
For example, if you want to re-sort the previous example by delivery date, under Sort by, choose delivery.
From the Order drop-down, select Custom List.
In the Custom Lists box, select the list that you want, and then click OK to sort the worksheet.
Follow these steps to create your own custom list for sorting:
In a column of a worksheet, type the values to sort by. Arrange them in the order that you want to define the sort order—from top to bottom. For example:
Select all of the cells in that list, and then click File > Options > Advanced.
Scroll way down to the General section and click Edit Custom Lists..
In the Custom Lists box, click Import.
Tip: For a short list—such as High, Medium, and Low, it may be faster to enter it directly into the List entries box in the Custom Lists box.
You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.