1. Select a column of alphanumeric data in a range of cells, or make sure that the active cell is in a table column containing alphanumeric data.
2. On the Home tab, in the Editing group, and then click Sort & Filter.
3. Do one of Following:
· To sort in ascending alphanumeric order, click Sort A to Z.
· To sort in descending alphanumeric order, click Sort Z to A.
Sort dates or times
1. Select a column of dates or times in a range of cells, or make sure that the active cell is in a table column containing dates or times.
2. Select a column of dates or times in a range of cells or table.
3. On the Home tab, in the Editing group, click Sort & Filter, and then do one of the following:
· To sort from an earlier to a later date or time, click Sort Oldest to Newest.
· To sort from a later to a earlier date or time, click Sort Newest to Oldest.
2. On the Home tab, in the Editing group, and then click Sort & Filter.
3. Do one of Following:
· To sort in ascending alphanumeric order, click Sort A to Z.
· To sort in descending alphanumeric order, click Sort Z to A.
Sort dates or times
1. Select a column of dates or times in a range of cells, or make sure that the active cell is in a table column containing dates or times.
2. Select a column of dates or times in a range of cells or table.
3. On the Home tab, in the Editing group, click Sort & Filter, and then do one of the following:
· To sort from an earlier to a later date or time, click Sort Oldest to Newest.
· To sort from a later to a earlier date or time, click Sort Newest to Oldest.
No comments:
Post a Comment