Using Forms to Add and Edit List Data

Table of Contents

This Book

Special Edition Using Microsoft® Office 2000

Search

About the Authors

Special Thanks To

Acknowledgments

Tell Us What You Think!

Introduction

Pt. I. Common Tasks

Pt. II. Office and the Web

Pt. III. Using Word

Pt. IV. Using Excel

Ch. 19. Excel Essentials

Ch. 20. Advanced Worksheet Formatting

Ch. 21. Using Formulas and Functions

Ch. 22. Creating and Editing Charts

Ch. 23. Working with Lists and Databases

Creating a List on a Worksheet

Speeding Up Repetitive Data Entry with AutoComplete

Automatically Filling In a Series of Data

Sorting Lists

Finding and Filtering Data in a List

Summarizing, Grouping, Outlining, and Subtotaling Lists

Using Forms to Add and Edit List Data

Importing and Exporting Data

Creating Links to External Databases

Creating and Using Web Queries

Troubleshooting

Secrets of the Office Masters: Smart Lists

Ch. 24. Using Excel in a Workgroup

Ch. 25. Using PivotTables and PivotCharts

Ch. 26. Error-Proof Data-Entry Techniques

Pt. V. Using Outlook

Pt. VI. Using PowerPoint

Pt. VII. Using Access

Pt. VIII. Using Publisher

Pt. IX. Using FrontPage and PhotoDraw

Pt. X. Automating Office with Macros and VBA

Pt. XI. Appendixes

Index

Using Forms to Add and Edit List Data

Data forms provide a simple method for entering data into an Excel list. By opening a data form, Excel creates a dialog box on-the-fly, based on your list's column headings. When you enter data in the form, Excel fills in the correct columns, adding rows to the end of the list, if necessary.

Tip

Although you can also use data forms to view and search for information in lists, this technique is rarely worth it. Sorts, filters, and PivotTables are much easier ways to browse a list. The advantage of using a data form for data entry is that Excel automatically adds each row you enter to the end of the list without requiring you to reposition the active cell.

PREVIEW

Not a subscriber?

Start A Free Trial

This Book

Search

Contents

Chapter 23. Working with Lists and Datab... > Using Forms to Add and Edit List Dat...

Using Forms to Add and Edit List Data