98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » ms excel training - Forms
ms excel training - Forms
Resolved · Low Priority · Version Standard
RE: Forms
Hi Olivia
Thanks for your question.
A data form is a dialog box that gives you a convenient way to enter or display one complete row of information, or record, in a list at one time.
Before you can use a data form to add a record to a new list, the list must have labels at the top of each column. Microsoft Excel uses these labels to create fields on the form.
1. Click a cell in the list you want to add the record to.
2. On the Data menu, click Form.
3. Click New.
4. Type the information for the new record.
5. When you finish typing data, press ENTER to add the record.
6. When you finish adding records, click Close to add the new record and close the data form.
I hope this helps and best wishes for your interviews.
Amanda
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Removing border lines on the keyboardHighlight your cell(s) that have boreders on them and press CTRL + SHIFT + _, this will then remove the border lines. |