advanced excel class - list management

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel class - List management

advanced excel class - List management

resolvedResolved · Low Priority · Version Standard

Rafael has attended:
Excel Advanced course

List management

How do I convert my database list in to a form?

RE: List management

Hi Rafael

Thank you for your question.

You can use a form interface in Excel to enter or edit information stored in an Excel list/database.

To enter data through a form interface:
1. Go to Data - Form.
2. Click the New button on the right hand side to add another row/record of information to the list/database.
3. Click Close.

To search for and edit a row/record:
1. Go to Data - Form.
2. Click the Criteria button on the right hand side.
3. Type in the criteria you are looking for from a specific field or fields.
4. Click the Find Next button to display the next row that contains the criteria you have searched for.
5. Edit the row/record information if you wish.
6. Click Close.

I hope this helps.
Amanda

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Quickly insert a function

In Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog.

Press Shift+F3 after a function name and open bracket to open the Function Arguments dialog. For example, type =VLOOKUP( into a cell and press Shift+F3 to obtain a detailed description of VLOOKUP's arguments.

View all Excel hints and tips


Server loaded in 0.09 secs.