Chapter 6. ORGANIZING WORKSHEET DATA
Enter Data with a Form
A list is a worksheet structured as a set of columns and rows. Each column represents a single type of data. In Excel, you can use a form to simplify entering data into a list. A form speeds up your data entry by providing a blank field for each column in your list. Place labels in the first row of your list. Your form will use these labels as field names. You type your data into your form and use the Tab key to move from field to field. After you complete each set of fields, you click the Next button to enter the record into a row in your list and then you type in a new record. You can move backward and forward through your list to view or modify your data.
Your form also doubles as a ...
Get Microsoft Office Excel® 2007 Data Analysis: Your Visual Blueprint™ for Creating and Analyzing Data, Charts, and PivotTables now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
