O'Reilly logo

Office 2010 Made Simple by Guy Hart-Davis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Sorting a Database by One or More Fields

When you need to examine the data in your database, you can sort it either by a single field or by using multiple fields.

TIP: If you need to be able to return a database to its original order, include a column with sequential numbers in it. These numbers may be part of your records (for example, sequential sales numbers for transactions) or simply ID numbers for the records; in either case, you can use AutoFill to enter them quickly (see Chapter 11: “Creating Worksheets and Entering Data” for instructions on using AutoFill). To return the database to its original order, you can then sort it by this column.

Sorting Quickly by a Single Field

To sort a database by a single field, click the column you want ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required