- Not only can Excel 2011 for Mac figure out number and date series on its own, but you also can teach Excel to figure out just about any series. You have two easy ways to make a new series with Custom Lists: Type a custom list from scratch, making entries in Excel Preferences. Start with an existing series of cells in a workbook.
- Click Home tab arrow under Sort & Filter, and then click Sort Oldest to Newest, or Sort Newest to Oldest. NOTE: If the results aren't what you expected, the column might have dates that are stored as text instead of dates. Convert dates stored as text to dates.
Many Mac users sort their files by name and type, but one of the most useful ways to sort files is by date. The Mac Finder allows for various different date based sorting options for files, documents, applications, and folders, and they’re all typically best utilized in the Finder List view. On a Mac however, it seems to be treating the same date field as text.so the sort might display 2Feb2007 before 3Jan2007 because 2 comes before 3.ignoring the rest of the date. The Mac user can take an extra step and change the format to 'date' manually but for some reason they must click on each cell.they can't do it by column.
This Excel tutorial explains how to sort data in alphabetical order based on one column in Excel 2011 for Mac (with screenshots and step-by-step instructions).
See solution in other versions of Excel:
Question: In Microsoft Excel 2011 for Mac, I'm trying to put a chart in alphabetical order. There are 6 columns and over 2,000+ rows of information. I need to sort the data by column B (ie: Product column) in alphabetical order. How do I do this?
Answer: To apply a sort in Excel, highlight the data that you wish to sort. Then select the Data tab from the toolbar at the top of the screen. Then click on the Sort button and select Custom Sort from the popup menu.
When the Sort window appears, select the data that you wish to sort by. In this example, we want to sort by the Product column (column B) in alphabetical order (A to Z). Click on the OK button.
Now when you return to the spreadsheet, the data should be sorted.
Excel 2011 for Mac has fantastic date and time calculation capabilities. When using Excel worksheets, you need to know just two secrets: Each day is represented by a whole number, called a serial number, and portions of days are represented by decimal fractions.
Finding today with Excel formulas
Some days, you wake up and don’t even know what day it is. Excel doesn’t have this problem. To have Excel return the current date, select the cell you want Excel to show the current date in and type the cell formula=TODAY() and then click the green Enter button. The selected celldisplays today’s date, and Excel automatically changes the format of the cell to Date.
Getting today’s serial number in Excel 2011 for Mac
Each day has its own serial number in Excel. If you follow the steps in the preceding section, you don’t see the serial number in the selected cell because Excel knows the formula represents a date. If you want to see the serial number instead of a date format, you can manually change the format of the selected cell to Number by selecting Number in the Ribbon’s Number Format pop-up menu.
In Excel, to add and subtract any number of days, just add and subtract whole numbers. You’re probably wondering how Excel arrived at the serial number of today. To find out, enter 1 in a cell and apply the Date format. The date changes to January 1, 1900 — the first day that Excel knows about. Every day in Excel is the number of days after 1/1/1900.
Finding the time of day with Excel’s formatting tools
Because Excel works with days as whole numbers, you might guess that portions of days are fractions. Well, you’d be right! Starting with a whole number representing a date, append .5 (one-half day) to a date serial number to represent noon. Apply the Time number format, and the time changes to 12:00 PM. Go ahead and try some different decimals.
Formatting a date in Excel 2011 for Mac
You have at least three different ways to apply a date format. Perhaps the fastest is to select a cell or cell range, and then click the Home tab of the Ribbon. In the Number group, click the pop-up button under the Number group title and choose Date to display the date as m/d/yy, where m represents the month’s number, d represents the day number, and yy represents a two-digit year.
How To Sort By Date In Excel 2011 For Mac Osx
Excel has many more built-in date formats, which you can apply by displaying the Format Cells dialog by pressing Command-1 and then clicking the Number tab. You can also display the Number tab of the Format Cells dialog by clicking the Home tab on the Ribbon. Then click the pop-up button under the Number group title and choose Custom from the pop-up menu.
How To Sort By Date In Excel 2011 For Mac
When the Format Cells dialog displays, select the Date category. Choose a Type from the list. Choosing a different Location (language) or Calendar type changes the date types offered.