Excel 2007 For Dummies
Book image
Explore Book Buy On Amazon

After you’ve created an Excel 2007 table (using the Table button on the Insert tab), you can choose from several methods for adding records to the table. Before you add records, the range must already be formatted as a table. To format a worksheet range as a table, select a cell in the range and then click the Table button on the Insert tab.

The most direct way to add new data is to press the Tab key when the cell cursor is in the last cell of the last record (row). Doing this causes Excel to add another row to the table where you can enter the appropriate information for the next record.

Another way to add records to an Excel table is to use a data form. The Form button isn’t included on the Excel 2007 Ribbon, but you can add this button to the Quick Access toolbar. To do this and access the data form, follow these steps:

Click the arrow at the right end of the Quick Access toolbar and select More Commands.

Click the arrow at the right end of the Quick Access toolbar and select More Commands.

The Excel Options dialog box appears with the Customize options displayed in the right pane.

In the Choose Commands From drop-down list, select All Commands.

You’ll see a long, alphabetical list of all the commands available in Excel.

Select the Form button in the list box, click Add, and click OK.

The Form button appears at the end of the Quick Access toolbar.

Position the cell cursor in the table and click the Form button on the Quick Access toolbar.

Position the cell cursor in the table and click the Form button on the Quick Access toolbar.

The data form lists the field names down the left side of the form with the entries for the first record in the text boxes next to them.

Click the New button in the data form.

Excel displays a blank data form, which you get to fill in.

Type the information for the first field and press Tab to move to the next field.

Continue typing data for each field in the record.

Press Enter to complete the record.

Press Enter to complete the record.

Excel adds the record to the table and displays another blank data form.

Press Esc or click the Close button when you finish adding records.

Your table will be updated with the new records.

About This Article

This article is from the book:

About the book author:

Greg Harvey has authored tons of computer books, the most recent being Excel Workbook For Dummies and Roxio Easy Media Creator 8 For Dummies, and the most popular being Excel 2003 For Dummies and Excel 2003 All-In-One Desk Reference For Dummies. He started out training business users on how to use IBM personal computers and their attendant computer software in the rough and tumble days of DOS, WordStar, and Lotus 1-2-3 in the mid-80s of the last century. After working for a number of independent training firms, Greg went on to teach semester-long courses in spreadsheet and database management software at Golden Gate University in San Francisco.
His love of teaching has translated into an equal love of writing. For Dummies books are, of course, his all-time favorites to write because they enable him to write to his favorite audience: the beginner. They also enable him to use humor (a key element to success in the training room) and, most delightful of all, to express an opinion or two about the subject matter at hand.
Greg received his doctorate degree in Humanities in Philosophy and Religion with a concentration in Asian Studies and Comparative Religion last May. Everyone is glad that Greg was finally able to get out of school before he retired.

This article can be found in the category: