Why can I not sort by date in Excel?

Why can I not sort by date in Excel?

Custom Format for using . is not recognised by Excel, hence that could be the reason it could not sort. Make sure you have no blank rows between the heading (e.g. “date”) and the date values in the column below the heading. These rows may be hidden, so be sure to unhide them and delete them.

How do I sort in Excel 2007?


  1. Select a cell in the column you want to sort (In this example, we choose a cell in column A).
  2. Click the Sort & Filter command in the Editing group on the Home tab.
  3. Select Sort A to Z. Now the information in the Category column is organized in alphabetical order.

How do I sort by date in Excel 2010?

To sort by date or time:

  1. Select a cell in the column you want to sort by. Selecting a column to sort.
  2. From the Data tab, click the ascending command to Sort Oldest to Newest or the descending command. to Sort Newest to Oldest.
  3. The data in the spreadsheet will be organized by date or time.

How do I remove a sort in Excel 2007?

Click on the sorting list that you wish to delete to highlight it and then click “Delete.” Click “OK” to confirm the deletion.

How do I sort multiple columns in Excel 2007?


  1. Introduction.
  2. 1Select or click in the list of data you want to sort.
  3. 2Click the Sort button in the Sort & Filter group on the Data tab.
  4. 3From the Sort By drop-down list, select the column by which you want to sort.
  5. 4From the Sort On drop-down list, choose Values.

How do I change text to date in Excel?

How to change text to date in Excel an easy way

  1. Select the cells with text strings and click the Text to Date button.
  2. Specify the date order (days, months and years) in the selected cells.
  3. Choose whether to include or not include time in the converted dates.
  4. Click Convert.

How to sort data by day of week in Excel?

Select a cell in your data.

  • Sort.
  • choose Custom List.
  • Tuesday from the Custom List dialog. Click OK.
  • How do you filter date in Excel?

    1. Select the Data column that you will filter by month later. In this case, select the Column B. 2. Click the Filter button under Data tab. 3. Click the Filter arrow besides the header of Column B. Then click Data Filters > All Dates in the Period, and then choose one month that you want to filter out.

    Why am I unable to sort data in Excel?

    The worksheet may be Protected. One of Excel’s features is the ability to ‘protect’ a worksheet, which can prevent it from being sorted, and even prevent it from being changed in any way. If this is the cause of the problem, you should be able to resolve it by unprotecting the worksheet.

    Why is excel not sorting properly?

    The most common reason for data not sorting correctly is due to the leading space ahead of the text. Many people using encounter this problem. The text with leading space is sorted at the top in ascending and at the bottom in descending order sort.