Post Ticker

6/recent/ticker-posts

Add Data Entry form in Excel

 Today I will say you how can I make the form.




You should active "Developer" Ribbon and add "Form". Follow the steps to make it:
Go to Files and then click to option, after click, you can see a window like bellow. Hear fllow, the steps-


You should active "Developer Ribbon". To active it
Step-01: You should go to "File" and select "Option" from there. Click to "Customize Ribbon"
Step-02: And then select "Developer" from "Mai Tab" 
To add "Form" follow the steps:
Step-03: Create a "New Group".
Step-04: Select "All Commands".
Step-05: Now find out "Form".
Step-06: Add it to the new group which has been created.
Step-07: Click to "OK" and now you are done.

Follow the flowing steps to entry data by this form:


Step-01: Select some header cells where you want to enter data.
Step-02: Go to the "Developer" ribbon.
Step-03: Click to "Form" which has been made.
Step-04: Fill up this form.
Step-05: Click to "New" and then you will be done.

Post a Comment

0 Comments