Creating Subsets of your Database

When use the AutoFilter or Advanced Filter command, you are in Filter mode.

In Filter mode, many Excel commands operate only on visible cells.

You can copy the subset of your data to another location. There are two methods,


Practice Exercise

You should attempt the Database - Exercises a-j from the Spreadsheet Exercises listed in the Topic Menu below.