|
| |
Microsoft Excel
Database Filtering
Description
Microsoft allows you to easily filter your Excel database
records so that you display only those records containing relevant
information. For example, you may wish to display only those records from
a particular zip code or those records with sales greater than a certain amount.
Use the steps below to filter your Microsoft Excel database.
In a Microsoft Excel Worksheet
- Open your Microsoft Excel worksheet that contains database
information.
- Click any cell within the database range.
Menu Path
- Click the Data menu.
- Select the Filter command.
- Select the AutoFilter subcommand.
- This converts each column heading to an expandable list box.
- HINT: Microsoft Excel will be able to identify your
column headings if they are formatted different than your
records. For example, format the column headings in bold.
AutoFilter Turned On
Filter Data
- Click the down arrow to the right of the column heading you
want to filter.
- From the drop list, select either:
- Top 10 to filter the top or bottom data in the
column Data must be either in date or numeric format.
- Custom to filter the data using criteria such as
greater than or equal to a certain value.
- Blanks to display only those records that have a blank
in this column.
- NonBlanks to display only those records that have a
value in this column.
- Or, select a value in the displayed list to filter.
- Continue to filter additional columns, if applicable.
Turn Off Filter - One Column
- Click the down arrow to the right of the column heading that
has been filtered.
- From the drop list, select All.
- All records will be displayed for that column.
Turn Off Filter - All Columns
- Click on the Data menu.
- Select the Filter command.
- Click on the Show All subcommand.
|
