How to Format for Ascending Date in Excel

Written by lysis | 13/05/2017

Microsoft Excel is a spreadsheet program that lists information in rows and columns. Excel can be used to create reports with charts and formatted layouts. One options users have to layout information is data sorting. Data sorting is used on columns to order the rows either alphabetically or numerically. Microsoft Excel has a built-in function that orders rows. One way to order the rows is by ascending date.

Double-click the Excel file you want to sort. This automatically opens the file along with the Excel application.

Use the mouse to highlight all the cells you want to sort. You can also click the top of the columns to highlight all the cells in that particular column.

Click the "Data Sort" button on the main toolbar. This icon has an "A" and "Z" letter.

Select which column you want to sort. In the selection, choose "Ascending" and press the "OK" button.

Tip

You can choose a secondary column to sort the columns.

Warning

Ensure that you select all of the columns, or you may accidentally rearrange important data.

Tips and warnings

  • You can choose a secondary column to sort the columns.
  • Ensure that you select all of the columns, or you may accidentally rearrange important data.
Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.