O'Reilly logo

Office 2010 Made Simple by Guy Hart-Davis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required