Plain old keyboard entry, just the same as entering any other worksheet cell data, seems a bit unglamorous and tedious. Still, typing in new records is just part of the bargain when you’re maintaining any list of information.

Whenever you type data into the next blank row below a table that you’ve defined on a worksheet, Excel automatically assumes that you want to add to the table, and so it adjusts the range defined as the table and formats the new record or row using the style applied to the rest of the table. For example, Figure 19-5 shows a new row of data being entered into the table from Figure 19-3.

If you add new row(s) or column(s) of data that aren’t automatically included by Excel, you can expand or resize the table. To do so:

1. Select Design?Properties?Resize Table.
2. Specify the range that holds the old and new table contents using the Select the New Data Range for Your Table text box of the Resize Table dialog box.
3. Click OK. Excel expands the table to encompass the new range.

FIGURE 19-5
Excel automatically expands the table to encompass any new row you type.

• Editing and Organizing WordPress Category Slugs In WordPress 2.7, when editing the categories or converting a category to a sub-category, the slugs will automatically replaced in...
• How To Fix A Table A beautiful table can make a room look much better and smarter. It is necessary to keep our house well...
• Triangle 101 There are a range of different metal percussion instruments that can be found in the modern western orchestra, even though...
• phpMyDB - Data base class for MySql phpMyDB is not only a class handler for MySql written in PHP, it's also has a query cache built in,...
• Excel How-to: The GETPIVOTDATA Function In a previous post, we created a simple pivot table from a list of Excel data.  Today, we'll link the...