Home OS Windows How to Sort by Date in Excel

How to Sort by Date in Excel

If you have already got a spreadsheet and that you must kind knowledge by date in Microsoft Excel or Excel Online, you may comply with this step-by-step information. You do not need to make use of any operate or formulation to kind knowledge as per your necessities.

How to Sort by Date in Excel

To kind knowledge by dates in Microsoft Excel, comply with these steps-

  1. Open the spreadsheet with Excel.
  2. Select the date column along with your mouse.
  3. Click the Sort & Filter button.
  4. Select Sort Oldest to Newest or Newest to Oldest.
  5. Select Expand the choice.
  6. Click the Sort button.

Let’s try these steps intimately.

Open the spreadsheet with Microsoft Excel in your laptop. After that, you must see a column containing all of the dates. You want to pick all of the cells which have a date. In different phrases, you shouldn’t select the header row.

Then, just be sure you are within the Home tab. If so, you may see a button referred to as Sort & Filter. After clicking this button, you must click on the Sort Oldest to Newest or Sort Newest to Oldest possibility.

How to Sort Data by Date in Excel

As the opposite knowledge of the spreadsheet should be modified in keeping with the date column, Microsoft Excel ought to present you a warning at this level. You want to make sure that the Expand the choice possibility is chosen. If sure, you may click on the Sort button.

How to sort data by date in Microsoft Excel and Excel Online

Now, your date ought to be sorted by date.

How to kind knowledge by date in Excel Online

To kind knowledge by date in Excel Online, comply with these steps-

  1. Open spreadsheet with Excel Online.
  2. Press Ctrl+ A to pick the entire spreadsheet.
  3. Click the Sort & Filter button within the Home tab.
  4. Select the Custom Sort possibility.
  5. Make a tick within the My knowledge has headers field.
  6. Select the date column, Cell Values, and Sort Ascending or Sort Descending.
  7. Click the OK button.

Read on to know extra about these steps.

At first, open the spreadsheet with Excel Online and choose the entire sheet. In case you have no idea the method, you may comply with our Microsoft Excel suggestions and methods information to know.

Now, just be sure you are within the Home tab. Here you’ll find an possibility referred to as Sort & Filter. After clicking this button, that you must choose the Custom Sort possibility.

How to sort data by date in Microsoft Excel and Excel Online

After that, select the date column from the Column record, choose Cell Values from Sort On record, and select Sort Ascending or Sort Descending from the Order record. At final, click on the OK button.

How to sort data by date in Microsoft Excel and Excel Online

Your knowledge ought to be sorted by date.

That’s all! Hope it helps.

How to sort data by date in Microsoft Excel and Excel Online

Most Popular

How to add a Transparent Image over Screenshot using Paint

Although Microsoft Paint is an previous app, its utility in performing varied duties hardly has any match. For instance, you need to use the...

Microsoft researchers claim ‘state-of-the-art’ biomedical NLP model

In a paper printed on the preprint server Arxiv.org, Microsoft researchers suggest an AI approach they name domain-specific language mannequin pretraining for biomedical pure...

How to convert Currency and get Stock Data in Google Sheets

By now we all know how simple it's to transform foreign money in Microsoft Excel, however what about Google Sheets? The software will not...

Apple replaces key marketing SVP Phil Schiller with Greg Joswiak

Having labored for Apple since 1987 — a number of years into the Macintosh period and almost a decade earlier than Steve Jobs returned...

Recent Comments