MS Excel Data sorting & Short Cuts

MS Excel Data sorting & Short Cuts

Another way to sort in Excel is with the Data Sort menu. The following explains how to sort by Last Name using Data Sort.

  1. Click the heading labeled Last to select the Last Name column.
  2. From the Data tab, click the Sort button.

  3. The Sort dialog box appears. Select the column heading that you want to sort by from the Sort by field
  4. In the Sort On drop-down, make sure Values is selected.

In the Order drop-down, select A-Z to sort your data by alphabetical order.

Click OK. The data will be sorted by alphabetical order.

Leave a Reply

Your email address will not be published. Required fields are marked *