• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Microsoft Excel Tips and Tricks - Computergaga

  • Home
  • Excel Online Courses
  • Excel Functions List
  • Free Downloads
  • Blog
  • Tutorials
  • About
Home / Excel Tips / The Excel Data Entry Form

The Excel Data Entry Form

The popular data entry form was removed from the Ribbon in Excel 2010. I am often asked where this feature went. So what is this feature? And where can it be found? Find out in this Excel tutorial.

What is the Data Entry Form?

The Excel data entry form makes it easy to;

  • Add new records to a table
  • Edit and delete records from a table
  • Search for records in the table

The data entry form is very user friendly and is a must for anyone who performs alot of data entry, especially in a large table.

Data entry form in Excel

Where is the Data Entry Form in Excel?

The data entry form needs to be added to the Quick Access Toolbar in order to use it. The form button will then always be just one click away.

  1. Click the Customise Quick Access Toolbar button and select More Commands
  2. Click the Choose commands from: list arrow and select Commands Not in the Ribbon
  3. Scroll down and select the Form control
Adding the Form button to the Toolbar
  1. Click the Add button and then Ok

To use the form, just click in any table cell and click the Form button. Excel will automatically detect the column headings.

Use the buttons to the right to add new records, skip through the tables records and enter criteria to find a specific record.

 Using the Form Control in Excel

Related Posts:

  • Lookup Multiple Values in Excel
    Lookup Multiple Values in Excel
  • Display Negative Time in Excel
    Display Negative Time in Excel
  • Advanced Excel Skills
    Advanced Excel Skills
  • Sort by Drop Down List in Excel
    Sort by Drop Down List in Excel

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Popular Posts

  • Excel Fixtures and League Table Generator
  • 5 Reasons Why your Excel Formula is Not Calculating
  • Excel IF Function Contains Text – A Partial Match in a Cell
  • Excel Formula to Display the Sheet Name in a Cell
  • 4 Alternatives to Nested IF Formulas
  • How to Hyperlink to a Hidden Worksheet in Excel
  • How to Create a Reverse FIND Formula
  • Check if a Value is an Even Number
  • IF Function in Power Query Including Nested IFS
  • Conditional Formatting Multiple Columns – 3 Examples

Recent Posts

  • SEQUENCE Function in Excel
  • Sort by Drop Down List in Excel
  • Advanced SUM Function Examples – The Power of SUM
  • Display Negative Time in Excel
  • Lookup Multiple Values in Excel
Advanced Excel Success book

Footer

Contact

[email protected]

Useful Links

  • Home
  • Excel Online Courses
  • Tutorials
  • Sitemap
  • Privacy Policy
  • Jobs by Jooble

Course Topics

  • Charts
  • Courses
  • Dashboards
  • Downloads
  • Excel Tips
  • Formulas
  • Mail Merge
  • Office
  • PivotTables
  • Power BI
  • Power Pivot
  • Power Query
  • VBA

Join Our Mailing List

© Copyright 2020 Computergaga · All Rights Reserved ·