Office 2010 Made Simple

Resizing a Database

When you've created a database, Excel normally resizes it for you automatically when you add or delete rows. For example, when you add a record by using the data-entry form, Excel expands the database to include it.

Excel also expands the database automatically if you add data to the row after the current last row in a database that doesn't have a totals row. Excel calls this feature Table AutoExpansion. If you don't want Excel to do this, click the AutoCorrect smart tag that appears below and to the right of the first cell in the added row, and then click Undo Table AutoExpansion (see Figure 15–7). Click the smart tag again, and then click Stop Automatically Expanding Tables.

Figure 15–7. You can use the AutoCorrect ...