When you need to store a lot of the same type of information in a worksheet, you can create a database in a table. For example, if you run a business, you can make a database of your customers and their orders.
The first step is to set up the table and to tell Excel that you're creating a table rather than a regular worksheet. The next step is to add your data to the table, either by typing it into the cells as usual or by using a data-entry form.
Once the data is in the table, you can sort the table to reveal different aspects of its contents or filter it to identify items that match the criteria you specify.
Before you start creating a table in Excel, it's ...