Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • LOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • How to get relative row numbers in a range in Excel
  • How to get first row number in range in Excel
  • How to use Excel MATCH Function
  • Count rows with at least n matching values

Data Analysis Examples

  • How to calculate current stock or inventory in Excel
  • How To Create Pareto Chart in Excel
  • Working With Tables in Excel
  • Create Scatter Chart in Excel
  • Use Data Form to input, edit and delete records in Excel

Data Validation Examples

  • How To Create Drop-down List in Excel
  • Excel Data validation must contain specific text
  • Prevent invalid data entering in specific cells
  • Excel Data validation unique values only
  • Data validation must not exist in list

Use Data Form to input, edit and delete records in Excel

by

The data form in Excel allows you to add, edit and delete records (rows) and display only those records that meet certain criteria. Especially when you have wide rows and you want to avoid repeated scrolling to the right and left, the data form can be useful.

1. Open the downloadable Excel file.

Worked Example:   How To Remove Duplicates In Excel Column Or Row?

2. Add the Form command to the Quick Access Toolbar.

3. Click the Form command.

4. Use the Find Prev and Find Next buttons to easily switch from one record (row) to another.

Note: use the New or Delete button to add or delete records. Once you start editing a record, you can use the Restore button to undo any changes you make.

Worked Example:   Randomize/ Shuffle List in Excel

5. To display only those records that meet certain criteria, click the Criteria button.

6. Enter the criteria and click the Form button.

7. Now, when you use the Find Prev and Find Next buttons, you will only see those records that meet these criteria. In our example, only record 13.

Worked Example:   Subtotal function in Excel

Note: to edit the criteria, click the Criteria button again. To close the data form, click the Close button.

Post navigation

Previous Post:

Add Outline to Data in Excel

Next Post:

Filter Data Based on Date in Excel

Leave a Reply Cancel reply

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

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to pad text to match equal length in Excel
  • How to abbreviate names or words in Excel
  • Split text and numbers in Excel
  • Get last name from name with comma — Manipulating NAMES in Excel
  • How to create email address with name and domain in Excel
  • Convert decimal minutes to Excel time
  • EOMONTH function: Description, Usage, Syntax, Examples and Explanation
  • How to get workdays between dates in Excel
  • How to calculate future date say 6 months ahead in Excel
  • ISOWEEKNUM function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate simple interest in Excel
  • DURATION function: Description, Usage, Syntax, Examples and Explanation
  • DISC function: Description, Usage, Syntax, Examples and Explanation
  • TBILLYIELD function: Description, Usage, Syntax, Examples and Explanation
  • Calculate interest for given period in Excel
© 2022 xlsoffice . All Right Reserved. | Teal Smiles