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

Lookup and Reference Examples

  • How to reference named range different sheet in Excel
  • How to get address of named range in Excel
  • Merge tables with VLOOKUP in Excel
  • How to get relative row numbers in a range in Excel
  • How to use Excel ROWS Function

Data Analysis Examples

  • How to calculate average last N values in a table in Excel
  • Move chart to a separate worksheet in Excel
  • Excel Bar Chart
  • How To Insert and Customize Sparklines in Excel
  • How To Remove Duplicates In Excel Column Or Row?

Data Validation Examples

  • Excel Data validation date in next 30 days
  • Excel Data validation must not contain
  • Excel Data validation unique values only
  • Excel Data validation allow uppercase only
  • Excel Data validation require unique number

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:   Advanced Filter in Excel

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:   How To Remove Duplicates In Excel Column Or Row?

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:   Reverse List 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 remove trailing slash from url in Excel
  • How to display conditional message with REPT function in Excel
  • NUMBERVALUE function: Description, Usage, Syntax, Examples and Explanation
  • How to extract text between parentheses in Excel
  • Get last working day in month in Excel
  • Roll back weekday to Friday base on a particular date in Excel
  • Get age from birthday in Excel
  • Convert Excel time to decimal minutes
  • How to get Holiday Date from Year in Excel
  • MDURATION function: Description, Usage, Syntax, Examples and Explanation
  • YIELDDISC function: Description, Usage, Syntax, Examples and Explanation
  • NPV function: Description, Usage, Syntax, Examples and Explanation
  • Calculate cumulative loan interest in Excel
  • SYD function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles