How to Create Excel Data Entry Form (No VBA) | Super Easy
HTML-код
- Опубликовано: 20 сен 2024
- #Excel
#MS_Excel
#Excel_2013
#Excel_2016
#Excel_Data_Entry_Form
In this tutorial you will learn how to create excel data entry form without VBA. This data entry form in Excel need just a few clicks. This is super easy to create and use.
The discussed data entry form is best to use for quick work in excel and to save time.
For more awesome tutorials please visit our channel "Microsoft Office Tutorials" at
/ microsoftofficetutorials
If you want to learn Excel in Hindi or Urdu language please hit the below link to Subscribe and learn Excel in Hindi / Urdu 😊
youtube.com/@MegaMindTech?sub_confirmation=1
very good so nice of you please show how to make drop down as well . u made it so simple , excelent
Dear sir... Plz answer can we add drop down list in this form.. That would be so useful
Thank you very much for your helpful and effective teaching on Excel Data Entry Form!
Cool 😎, that's so simple than other channels 😉. Thanks sir
Thanks
It is so easy and understandable.
Thanks so thanks
Welcome
Many thanks, you made life easy for me, from Amman-Jordan,,
Pleasure, my brother ❤
Really I should have learned it before, many many thanks sir.
Really very superb job you have for us. Thank you so much but can i create invoice in this method...If yes please post another video for me i am working in metal scrap company...I already created in my own way but it's too lengthy...We purchase more than 30 items each time or each customer material qty and rate also differed... Please explain me how to do. Thank you.
you are very much appreciated! made a stressful task so easy!! thank you!
Very Thankful to you for this amazing session . very easy to understand. Stay blessed.
Thanks ❤️
@@MicrosoftOfficeTutorials can you show us , if I want to make the billing of client , ( want to take printout also)
we need this types of video more. its very help full for us.thank you.
👍
Hi sir
Can you explain that again please
And can you uses
Slow way
@@at494949 Try this: Use the "Settings" (gear) in the lower right portion of the video border to change the speed. Here you will be able to speed it up or slow it down.
Absolutely LOVE this, thanks sooo much. Hate Vba so this is easier and perfect
You are truly Awesome. thank you so much
Wow that's is so simple and easy to understand good work 👍❤
Great, its easy and prolific. Just wanted to ask that does this method allows creating combo boxes and entering long texts? Response awaited. :)
Thank you for sharing this extremely helpful information.
thank you for your nice technique to Data Entry. This is unique method.
This was a great beginners tool on creating a Database without knowing VBA! Is there any possibility that you can add more videos that add upon this... towards making a CRM database, (like ACT!) perhaps? For example, I would be interested in how to add Word, Excel, and Pdf docs, if I made a "documents " column. Any videos that can add to this would be helpful..thanks for sharing!!
I was really amazed!!thank you for the tips😍i can really use this for my job😍.new subscriber
Thanks for the explanation. Is it possible to add drop-down list to the form?
Hi, no not possible in this forn
More knowledge added in my head thanx...im using excel 2019 no problem
I am using MS Excel 2007. I am unable to do this.
Thanks
Frank Valle po
@@purnendushaw5490 It's No Problem in Excel 2007. You will find your option to do some work. You can get your table in Insert ribbon & form button get from File > Excel Option > Customize > Choose Command form > Command not in ribbon.
I have recently subscribed for your channel. You are amazing the way you explain and illustrate the content. I have a question how can we play with reindeer and alerts based on dates.
For example if I have today’s date and I want Excel to Remind me exactly after 4 weeks from today’s date.
So good! thank !
Your voice of tone and way of learning so simple :] great sir
Agree
Thanks for sharing!!! I watch yours and VANNA EXCEL for my marketing work!
Excellent demo, simple and easy to folllow. Good work!
thanks
Thanks brother. something very new
Thanks ❤
Suppose a table has a column Category. When we fill in, we should put 'General', 'SC' or 'ST' Can it be possible to show user form where category can fill by drop down.
What type of Excell version is this?
Superb tutorial, good presentation and explanation
THANK YOU SO MUCH ♥️
Very good information. Thanks. how to avoid duplicate data entries in form? Kindly explain.
Love it. I just learned another thing. Thank you
That's nice and easy way to understand, could you make one more sample for shop invoice records by bill no. And date
Millions of thanks sir👍
This is really helpful. thank you.
Thanks ❤ alot bro...
Great job and simple..thanks
Thank you
Will possible to input data from drop-down list in the above form ?
No, not possible in this data entry form
wowww really cool video. and easy to understand. and the way u explained was marvelous. stay blessed bro
Thanks very much for tutorials, I like to know if there is a
way to make just a cell behave as a normal calculator.
i.e this cell should be capable of summing figures that
appears in another cell, while keeping last cumulative figure visible.
This other cell will be the key-in cell or active cell.
Example:
Cell 1: =2*5, Answer appears in Cell 2,
Cell 1: =3*6.8, Answer is added to the previous value
resulting from (2*5) and still appears in cell 2.
Can we use drop down list in this?
Wow.. hi sir please make a program cashiering here in excel thanks
Great job
Will this same Excel template works in Google sheet . If it works let me know how it works?
thank you so much for sharing .
Welcome brother ❤
Excellent video! Thank you, for sharing!!
I never knew this feature exists. Thanks!
That's amazing thanks for helpful video.
👍
Awesome
If possible please respond where peopme use this function more n more
Thanks
Good👍
Thank, thank you very much.. brother
This is excellent. I need your help. How can I make data Base form that can allow me to enter marks of different subjects, and find position average, total,and prepare parents report cards automatic?
Very nice video. My question is can we put the form in one sheet and table data in another sheet and the table data can be protected with password. Thanks in advance.
That was Awesome
Great video! Question: How do I allow entering multiple employees for 1 date?
Good.informative session
y r great sir thank u very much for great helpful information
Welcome ❤️
Superb dear you are doing well 🎁🏆
Thanks. Glad to know you like it
I never knew this.. This is brilliant. Thank you for showing us how to create this!
Genious!
nice and quick, thanks
It pretty awesome... thanks SIr! ❤️👏👏
thank you so so much
Welcome 🙂
Hey thank you for the video..
Is there a way to open the forms when another user opens the workbook.
I want the forms to pop up when we open the workbook so that the people can start writing typing in.?
excel-lent explanation...
Using "Criteria" button is it possible to modify any record entry/field.
Yes, we can search with criteria button and can change
Thank you
its very informative
thanks man
Nice . Very useful tool 'form'
Thanks ❤️
3e7ttt7t and by in in 7t7t
Every time I ad someone new to the data base it overrides the older clients, please help? Love the vid
Good talent Thanks bro
Great ,Very useful
Thanks
Excellent,
How can we create option to create history of additional information for each records
thank you great job
Can we consolidate automatically without a manual intervention
I love this demo I have just tried it but, if using entries with dates is there a way for entries to sort automatically in the forms by date
Data tab -> then turn on your filters
Very nice sir
To do this example is it necessary to have Windows 10?
Can we make a form, the data in which can be separated in 3 different sheet based on a particular criteria?
Nice video but please zoom the file options for this so that everyone can see where is the options and what u di with salary like xsalary something
I'l try this step but it cant be operated with many fields.. How to solve with this issue? Tanx for the learnings
So interesting and beneficial
Informative
This extermly super
Hi can we consolidate these forms filled by different employee from their system and put on a share drive
Good Demo
Good video.
Thanks
I have one doubt. We can't make shared this file. How multiple user will use one file
Can we put the picture also or not in this as we can put it in VBA
Hi Sir, how it can be ensured that duplicacy is not there in dataentered in the form.
Super bro
Thanks ❤️
Brother, can you also show how to search names by direct entering his or her name from this data
does this work in mobile?
I cannot use the simple data entry form, giving me error "Too many fields in the form"....right?
Sir I have question how the net pay it's is writing automatic number
DEAR sir mera ek question hai apne ye data entry bnana btaya jaise hm invoice bnate hain ek company wale 20se 30br ya kbhi v kuch bhi saman lete hain shops se to hme bill bnane k liye unka company ka name tax number address sb fill krna padta hai, kya aisa koi solution hai jis mai hm sirf company ka name menthion kren or uski puri details khud aajaye please help me
I have around 36columns want to put form, is it possible without vba? tq
so I'm doing a data entry and when I check the quick access toolbar in the commands not in the ribbon I can't seem to find the form selection
Can you restrict data from being deleted by other users?
Soon will upload a tutorial on this topic