ms excel training - forms

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » ms excel training - Forms

ms excel training - Forms

resolvedResolved · Low Priority · Version Standard

Olivia has attended:
Excel Advanced course

Forms

How do you use a form to enter data?

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



 

Excel tip:

Removing border lines on the keyboard

Highlight your cell(s) that have boreders on them and press CTRL + SHIFT + _, this will then remove the border lines.

View all Excel hints and tips


Server loaded in 0.11 secs.