Easy Microsoft Office 2003

2017-07-07 02:10:07

Select a cell in the column you want sorted alphabetically or numerically (depending on whether the sort column contains text data or numeric data).

Click the Sort Ascending button on the Standard toolbar.

The data is sorted alphabetically from A to Z or numerically from the lowest amount to the highest. Click the Sort Descending button.

This sorts the data alphabetically from Z to A, or numerically from the highest amount to the lowest.

INTRODUCTION

You can easily change the order of the data in your worksheet. If, for example, you want to alphabetically arrange the names in a data list of sales representatives, you can sort on Last Name. Alternatively, you might want to sort your sales representatives by the region in which they work or by YTD sales.

TIP

Sorting on Multiple Columns

To sort on multiple columns of data, select Data, Sort to open the Sort dialog box. Select the first Sort by column name (for example, Region) from the drop-down list box; then choose up to two more options from the Then by drop-down list box (for example, YTD Sales). Make sure you indicate whether you have a header row (if not, the columns will list as Column1, Column2, and so on), and click the OK button to perform the sort on your data.

INTRODUCTION

TIP

Категории