• 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. In this example, we want to sort by the Product column (column B) in alphabetical order (A to Z).
• In an Excel workbook, start off by clicking in a cell of the column you want to sort. Now, make sure that you're on the Home tab of Excel's ribbon, and find the Sort and Filter button on the far right side of it. The Sort & Filter button lives on the far right side of the Home tab on the ribbon.

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.

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.

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

How To Sort By Date In Excel 2011 For Mac Catalina

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.

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.

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.

How to sort dates in chronological order in Excel?

How To Sort By Date In Excel 2011 For Macs

Supposing you have a date list mixed with multiple date formats as below screenshot shown. In this case, Excel can not sort them correctly by using the Sort function. But, you can convert all different date formats to a specified date format such as mm/dd/yyy first, and then sort them in chronological order, how can you achieve it? This article will show you a method to deal with it.

Sort dates in chronological order in Excel.

Here we introduce the Convert to Date utility of Kutools for Excel to help you convert all dates to mm/dd/yyy date format in bulk, and then sort them in chronological order in Excel. Please do as follows.

Before applying Kutools for Excel, please download and install it firstly.

1. Select the date list, click Kutools > Content > Convert to Date.

2. Then a Convert to Date dialog box is opening, and dates in the selected list are converted to mm/dd/yyyy at the same time. Please close the Convert to Date dialog box. See screenshot:

3. Keep selecting the date list, click Data > Sort Oldest to Newest or Newest to Oldest as you need to sort dates in chronological order. See screenshot:

If you want to have a free trial ( 30-day) of this utility, please click to download it, and then go to apply the operation according above steps.

Related articles:

• Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
• Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
• Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
• Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
• Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
• Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
• Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
• Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
• More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.

• Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
• Open and create multiple documents in new tabs of the same window, rather than in new windows.
• Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!

How To Sort By Date In Excel 2011 Mac