How to Sort in Excel 2007

By Joshua Laud

When you use Microsoft Excel 2007 with large amounts of data, it is often necessary to reorganize or sort the data. When you enter information that is constantly updating, you might need to sort that data in order of size or any other attribute. Excel 2007 makes it easy to sort using the Sort tool. Sort allows you to arrange data depending on column or row.

Step 1

Click "Start," "All Programs," "Microsoft Office," then "Microsoft Office Excel."

Step 2

Click "File," click "Open," then locate a document that has a table of data that you need to sort.

Step 3

Highlight the table, including the column titles.

Step 4

Click the "Data" ribbon, then click "Sort." Click the "Sort by" drop-down menu and choose the column that you wish to organize your data by.

Step 5

Click the "Sort On" drop-down menu if you want to change this feature. "Values" will sort the data by values, but you can also sort by "Cell Color," "Font Color" and "Cell Icon."

Step 6

Click the "Order" drop-down menu and select the ordering for your document. The phrasing for the type of ordering will change depending on data type. With numerical data it will show "Largest to Smallest" and "Smallest to Largest," and with qualitative data it will show "A to Z" and "Z to A."

Step 7

Click "OK" to sort your data.