NOTE: When you use AutoFilter within a database, the row numbers will turn blue, and the results of the filter will appear in the status bar (e.g., 1 of 12 records found).Ī custom filter allows you to select a "range" of information or set multiple criteria.įrom the appropriate pull-down menu, select (Custom Filter… ). Rows meeting the filter criteria are now displayed. Activating AutoFilterįrom the Data menu, select Filter » AutoFilter.Ī pull-down menu will be placed next to each column heading within the selected database.įrom the appropriate pull-down menu, select a value to use as filter criteria. These menus are used to select the field contents, which determine what records will display. The AutoFilter command applies pull-down menus directly to the column headings in the database.
Most of the Edit menu commands affect entire rows, not individual fields (cells).ĪutoFilter works for most filtering needs, but when you have complex criteria or want to create a copy of the information, use Advanced Filter. When deleting data from the database, entire rows must be deleted. The Sort command will affect visible cells. When printing the database, only visible cells will be printed. Cell formatting affects only visible cells in the database. Some effects of filtering a database include the following: NOTE: The pull-down menus located at each column heading help remind you that the filtering is turned on. Cautions for Working with FiltersĬommands in Excel can have different results on database records while using filters. Using a filter allows you to work with a portion of the records in your database by extracting only records that match a set of criteria. This article is based on legacy software. (Archives) Microsoft Excel 2007: Filtering Your Database Mac
0 kommentar(er)
