For more information, see Turn on Chinese language features. Type the name of the first item in the list into the cell. For example, if you want to sort or fill by the following lists, you'll need to create a custom list, since there is no natural order. Custom lists. Under Order in the same row, click A to Z , and then on the shortcut menu, click the criteria that you want. Under Orientation , click Sort left to right , and then click OK. Along with its robust features like automatic calculations, conditional formatting, charts, and such, Microsoft Excel offers some simple features that can save you time.
Sandy Writtenhouse on August 30, Along with its robust features like automatic calculations, conditional formatting, charts, and such, Microsoft Excel offers some simple features that can save you time. One of these features is the ability to create custom lists. Custom lists can be used over and over on your spreadsheets. This is handy for things you use often like product, employee, or attribute lists.
Open Microsoft Excel on your Mac. You can open the workbook where you want to insert the custom list or any other workbook since the lists are reusable.
You will see those list items automatically populate in the Custom Lists box. You may already have a list of items in an Excel spreadsheet that you want to transform into a custom list. This is also easy to do.
You will see those items populate in both the List entries and Custom Lists boxes. Fill in the remainder of your list manually.
You may also use the down arrow to go to the next cell, or simply click on it, to continue typing items that need to be on your list. Cooper Temple has over 15 years of experience writing procedural and training material for a Fortune company.
In Excel for Mac, you can sort a list of data by days of the week or months of the year. Or, create your own custom list for items that don't sort well alphabetically. Use a custom list to sort or fill in a user-defined order. Excel provides day-of-the- week and month-of-the year built-in lists, but you can also create your own.
His articles specialize in productivity programs and other business-related software. Skip to main content. References 1 Microsoft Office Mac: Have Excel Complete Your Lists.
About the Author Cooper Temple has over 15 years of experience writing procedural and training material for a Fortune company. Accessed 18 February Temple, Cooper.
How to Make a List in Excel for Mac.