O'Reilly logo

Microsoft Office Excel® 2007 Data Analysis: Your Visual Blueprint™ for Creating and Analyzing Data, Charts, and PivotTables by Denise Etheridge

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

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

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