Jump to content

Simplify data entry


Recommended Posts

Simplify data entry with Excels built-in form

If your spreadsheet has more columns than can fit on your computer screen, you can use Excel's built-in data form and spare yourself a lot of scrolling.

To use the data form, select any cell within the spreadsheet range and go to Data | Form. Select New to enter a new record, and Excel will display a blank form. Enter data in the first field, tab to the next, and continue to enter data in each field, tabbing between fields. Press [Enter] to go to the next blank record.

If there are calculations in your spreadsheet, Excel will display only the results on the form. This prevents users from inadvertently overwriting formulas. To delete a displayed record, click Delete. A warning box reminds you that the record will be permanently deleted after you click OK.

Follow these steps to search for a record within the form:

1. Click Criteria to clear the form.

2. Enter keywords in appropriate fields (e.g., enter Jones in the Lastname field).

3. Click Find Next (or Find Previous).

If you enter search criteria in more than one field, Excel will find the next record that meets both criteria. The form doesn't support OR searches. Use the scroll bar to browse through the records.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...