data entry form

Muhammad Asif 121 Reputation points
2022-11-18T17:57:32.847+00:00

I want to make a data entry form in excel

id no:
name:
father name:
order date:
contact no:
amount:
payment method:

these entries on the form and if I enter id no in front of id no it shows all data of of relevant id no and am update this data as per my requirements

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,736 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Charles Qi_MSFT 971 Reputation points
    2022-11-21T06:05:20.657+00:00

    Hi, @Muhammad Asif

    You can use the following steps to add data entry form to quick access toolbar:

    1. Right click on existing icons in the quick access toolbar,
    2. Click on 'Customize Quick Access toolbar',
    3. In the 'Excel Options' dialog box that opens, select the 'All commands' option from the drop-down,
    4. Scroll down the list of commands and select 'Form',
    5. Click on the 'Add' button,
    6. Click OK.
      Then you can select the table which contain all the data and click the icon.
      If you want to update the data, you can use find function and change the data in the table.

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in email-notifications to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.