Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Creating forms on excel spreadsheets
Resolved · Medium Priority · Version 2003
Esson has attended:
Excel Advanced course
Is it possible to create a form that will populate fields within your database?
Hello Esson
Thank you for your question.
There is an in-built form in Excel that you can use to add new records to a database.
To add a new record:
1. Select a cell within the database.
2. Go to Data - Form
3. Click New, and enter data into each field.
4. Click Close when finished. The new record appears at the end of the database.
Kind regards
Amanda
Mon 6 Jul 2009: Automatically marked as resolved.
|
|
Excel tip:Editing a formula quicklyIf you want to edit a fomrula or text quickly witin a cell instead of the formula bar, you can click either double click in the cell or press the F2 key |
TrustScore
4.9
/ 5
2224 reviews
Connect with us:
We will call you back
Call for assistance
Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
We'll call during UK business hours
Server loaded in 0.08 secs.
