ms excel training - forms
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

replyReply Wed 20 Jun 2007, 16:43Delegate Olivia said...

Olivia has attended:
Excel Advanced course

Forms

How do you use a form to enter data?

For upcoming training course dates see: Pricing & availability

replyReply Thu 21 Jun 2007, 13:44Trainer Amanda said...

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:

Hiding a worksheet in Excel

Want to circulate an Excel workbook file but keep certain worksheets hidden from your colleagues' view?

You can do so by bringing up the sheet you wish to hide on your screen; then going to Format - Sheet - Hide.

It will not be immediately obvious that a sheet is hidden from view unless perhaps the sheet are still labelled Sheet 1, Sheet 2 etc.

To display the sheet again, you can go to Format - Sheet - Unhide on any of the other sheets in the workbook. A dialogue box will appear, allowing you to select the hidden sheet/s. Click OK to make the sheet/s reappear again.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard