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

ms excel training - forms

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

ms excel training - Forms

ResolvedVersion 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:

Go to source of a cell

The default setting in Excel is when you double click in a cell it actives the formula in the cell. If you have created a link and want to directly go to that link (say if on another sheet, click on Tools -options and take off the tick for eidt it directly in cell

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.