SUPER EASY Excel Data Entry Form (NO VBA)

[@LeilaGharani]

Sign up to our free newsletter and start your week with Excel hacks, Office tips, and the latest AI updates.: link.xelplus.com/yt-c-newsletter

[@tapan4253]

will do but now, i have one quarry, for example, if i have 10 companies and 10 sheet , so when I fill the data entry form, that data gets saved in the sheet of the company for which I have filled the data. how to do it?

[@ckokse]

You must be kidding. I had no idea this even exists. Just to think how often I could have used that in all those years ... Why is that hidden??? Anyway, thank you Leila. This is really awesome!!

[@LeilaGharani]

I'm glad you like it. It can really be useful.

[@jennifer7685]

Leila Gharani is it a new feature? I could have used this literally 40x per month for the last 11 years

[@kgfes]

@@LeilaGharani Beautiful isn't it😊 . I just realized i can also use this technique to check for and correct errors in a table already filled

[@ouraniagrimes2731]

@@jennifer7685 Me too!!!

[@name1927]

very useful

[@arnelaguha8356]

I got promoted in my job because of your videos. I could never have done it without these. You are great! More power!

[@kimanga0014]

Support her

[@Wintershot11]

I LOVE how quickly you move through this. Simple and without a lot of fluff. This could have been a 20 min vid from some others. This was awesome. Thank you!

[@MareeTeolanafo]

The form existed in the older Excel versions (Tools menu, I think). I remember using this for data input many years ago. I had no idea it still existed. Microsoft tends to hide the goodies! Already added to my QAT. Thanks for sharing.

[@JAFFER3657]

every time I click your videos I learn something new and that too in a very quick and professional way, Thank You :)

[@LeilaGharani]

I'm very happy to hear that Syed!

[@ifaniabu]

@@LeilaGharani Hi Leila hw r you I wish to learn Access Program to build a mini software could please let me know the details about that thanks and regards Ubaid

[@stewartdahamman2472]

@@LeilaGharani Have you spent time in Ireland? Because I can hear it in your accent!

[@user-eq7dk2lk2d]

Do you know, Leila, you switched us from amateur to professional in Excel, thank you sweet queen. thanx

[@LeilaGharani]

That's my mission actually! I'm happy I can contribute to your development.

[@briannakingsley360]

Hi! I've been teaching myself Excel for fun! I've found ALL your videos very thorough and clear, thank you for explaining difficult topics like data entry, or drop down menus in easy understandable ways!

[@LeilaGharani]

Wow, thank you Brianna!

[@ryanjohanides5347]

The keyboard shortcut is Alt+D+O when you’re clicked on a table. However, there seems to be a limit on power query tables. :)

[@PHWiest]

Alt, D, O

[@Mandelbrot567]

Great tip. As far as I can tell the form facility does not produce combo boxes for multiple choice, but it does apply data validation to the text box. Hence, VBA forms still have some advantages. Thanks Leila!

[@LeilaGharani]

True, VBA is much more flexible. This is just an alternative that is simple and works without it.

[@Mandelbrot567]

@@LeilaGharani I agree, it is one click (form) versus maybe hours of coding. (VBA).

[@sguchait]

You are simply awesome. All this while, 10 years, working with Excel - i used VBA to create a data entry form. I had no idea this option was available already. You are great Leila.

[@LeilaGharani]

That's what keeps it interesting. There's always new stuff to discover :)

[@sguchait]

@@LeilaGharani ..Thank u for your response..i had a query in excel , about filtering a set of data..i dont know where to ask you.. I had posted my question in two of your youtube videos..but you haven't responded yet. Is there any email address, or location where, if i ask the question, you may respond..please...

[@LeilaGharani]

Best is to post your question on the Microsoft Tech Forum for Excel. With over 25K members and almost 30K posts, your solution is either ready and waiting or has the possibility of being answered more quickly than we may be able.

[@satinderhayer7825]

Hey Leila, Great Video as always. Just a small tip i found to make it more useful, if you want to increase the width of the entry form, just increase the width of ANY column of your underlying excel column. The form takes the width of largest column. Thanks.

[@ScottAnders62]

Wow, Leila! I never knew about this. I've been building forms in vba for years. Thanks for providing so much value in your videos. I thought I was really good at Excel until I found your channel, lol!

[@shadrackawunyo7786]

There's always something new to learn each day in Excel.....

[@sarfarajkureshi6569]

Mam from your every video I am going to learn something new and helpful. Today I am learn data entry in excel. I don't have any teacher except you for excel.

[@LeilaGharani]

I'm glad to hear that you find the videos useful.

[@dilipwarrier5199]

That was awesomeeeee...all these years I used to waste time creating forms...this is a life saver!!! Thanks a lot, Leila!

[@crazygoat5321]

Ma’am, I have only recently discovered you KZbin site…. It is amazing. Thank you for all you information, please don’t stop. The way you present the information and the example you give are priceless…thank you

[@excelisfun]

Thanks for the Old School Excel Fun!

[@LeilaGharani]

Old school is the Fun School :)

[@excelisfun]

@@LeilaGharani Sometimes... But the Old School does not have Power Query, M Code, DAX, Power Pivot or Power BI... : (

[@purvisinghraghav1910]

HI IAM PURVI I LOVED THIS VEDIO

[@temayet2270]

thank you so much for sharing this.....

[@Aboulchad002]

Clash of the titans.

[@rashidazzan36]

I love this women thank you for the much needed excel education god bless you.

[@sarkarbadshah7499]

Not god ALLAH

[@susanmorris1007]

Thanks! I was asked to make a form for info about our homeless clients. This is extremely timely and simple way for me to do this!

[@computerdoctorshow1470]

Ive watched your video several times because i had to set up data entry forms for several customers ... nice job, thank you

[@nonsoamamchukwu9598]

For all I can say: Thank you for the simplified lesson! It was well learnt.

[@LeilaGharani]

Glad you like it Nonso :)

[@JoseRivera-jt5ek]

Amazing. You’re so awesome, I think you just saved me weeks of work into a couple of minutes. Thank you for opening everyone’s eyes to these hidden forms!!!

[@herwigsyen804]

Watched your video 2 days ago, today I'm already implementing, saving me the arrow right between entries and saving time in the process. Thanks!

[@LeilaGharani]

It's great you could already implement it.

[@humorous2me]

2 years later and your video is still right on time. Thank you for being my Excel coach!

[@johnmccormick2883]

Great Info … much appreciated! I was also hoping to see if you have a table that has a great many columns, how to make forms that are specific to only certain selected columns.

[@pietrobissolati5882]

Try to hide the column(s) you don't want to show in the form. It seems to works fine......

[@pippyfari]

That would be a great help! I am working on a table with many columns, so when I create a form, thats cool, however when i click on form I get an error message regarding too many fields

[@johnmccormick2883]

@@pippyfari I ended up writing a macro to hide and un hide the columns that I needed to enter data in… the macros weren’t very hard and then I assigned shortcut keys to each macro

[@pippyfari]

@@johnmccormick2883 Thanks brother

[@fredericktruter5292]

Always something new to learn, thank you.

[@LeilaGharani]

That's good though, right? Otherwise it would be too boring :)

[@fredericktruter5292]

@@LeilaGharani there used to be an add in "Template Wizard With Data Tracking" for earlier Excel versions extremely powerful and not available any more. I trust you know what can be used in its place?

[@LeilaGharani]

I guess you have to create your own macro/VBA code for that. I don't know of another add-in that replaces this...

[@SalehCh]

I am learing excell and really Know nothing , but I find your Video is very helpfull to me as a beginer. Planty of vedioes are avilable but many of them I don't even understand why they are uploading ............ You are nice indeed.

[@threeaxis359]

At my work I entered data for cycle times for parts amongst other data for a part number this would have made it so much faster and easier to finish the project. Will definitely use it in the future Thank You Leila you are amazing.

[@simdog635]

Another very interesting Video, I wasn't aware of this function in Excel. Thanks again

[@LeilaGharani]

You're very welcome Steve. Glad you like the video.

[@veilagonzalez390]

This is amazing, I was able to do it quick and easy. Thank you! Please do tutorials for how to construct a table with the ending report in mind like satisfaction survey evaluations, events participations, mailings etc. Your advice is amazing.

[@LeilaGharani]

It really is a simple solution that is often overlooked. Many thanks for the feedback. I'll consider it.

[@Timurlane100]

Really impressive. In two days of casually watching your videos, I've learned more useful techniques than from a month-long course.

[@LeilaGharani]

Great to hear!

[@waridkarachi]

You are an amazing teacher of Excel, no doubt you have great command over Excel

[@lorrimdavis]

Thank you so much! It is always amazing to see these tools doing more than a "budget" :D

[@LeilaGharani]

Even these simple things can be quite useful sometimes :)

[@DocBizzle]

I love your voice! And of course, I greatly appreciate all of the awesome Excel tips you share!

[@efeveesse]

So do I. Her tips are awesome as well 😁

[@sternritter9788]

Thank you so much for this! My manager wanted me to create an inventory list that subtracts from the total inventory every time we enter a new set of inventory. With this form, I can now easily enter new data sets!

[@LeilaGharani]

Glad it helped!

[@jimmyta5092]

Thank for this. I had previously use date form and it was great. Now all of a sudden it's gone. Thank you for showing how to find it in Excel.

[@mohamedsafeer3850]

You are genius

[@ChristianAndreassen]

Great video Leila. Very useful tip - its going right into my current project :)

[@shelleycrooks2119]

I have gone from illiterate to amateur in Excel. By Watching videos and reading online. I am sure. I can use this Somehow in my business. We need to Record employee's sick and vacation days. I would like to somehow have them Enter their information in a form. And it goes to my spreadsheet. I was able to Do that with Microsoft forms but it had to come From the person Who was logged in. I steal like this video is putting me in the right direction. But not sure. Where to put this form so that the staff could access it. . You did a great job And I really appreciate when people show how to fix mistakes!

[@jackzouyuquan9094]

Explanation very good. Other teachers talking very fast. So I don't know what they are talking. You talk slowly and steady so that I understand. And you clicking computer very clear. I like your teaching very much. Thanks

[@pradhanbalter3796]

Hi Leila! Quick question, can the ez forms created this way be customized at all? For example, can a field be made larger for entering more data? Or can any other type of entry types be added, eg, option boxes, check boxes etc? You're the best! Keep those "t's" coming!

[@batarasiagian9635]

Oh how I wish you had been around in the 80s when I first started working with spreadsheets. :) Many thanks for your informative and always useful videos.

[@LeilaGharani]

You're very welcome. I'm happy you find the videos useful!

[@azis7281]

I never knew it existed. Would have been easy for so many tasks I did in past years. Thanks for this. Learning never stops even if you are too old.

[@hemantmehta5470]

Its very good to learn from you Leila. You Make concepts very simplified. daily I see your MS Excel Training Videos. Many Thanks Leila.

[@OzduSoleilDATA]

Good stuff! That form is easy to forget about.

[@LeilaGharani]

It sure is! Thank you Oz.

[@VictorLeva]

Thank you for all your videos Leila, very useful information and well done videos. I have one question for you on this function, can this forms be used in Excel Macbook? I spend a lot of time looking for the icon FORMS and I could not find it. Please let me know if there is a way to do the FORMS in Mac Excel.

[@alainndayiragije5503]

Many thanks Leila, everytime I watch your Excel tutorial videos I learn something new.

[@LeilaGharani]

Happy to hear that, Alain!

[@mohammedhassan2808]

You open the treasure to the common excel users, how to do maintain a table with Form without VBA

[@whitecriss]

Excellent presentation, thank you very much! :)

[@LeilaGharani]

You're more than welcome Cristian! Glad you like the video.

[@mgtubb]

This is once again great! Thanks for this tutorial Leila. May I ask one question regarding using data validation: what doesn't seem to work is using the drop down list function in data validation, meaning in the entry form choose the right value or text from a list.

[@konsamprincesingh7763]

Its amazing. I am not comfortable with Visual Basics. So this is kind of a useful excel trick. Thanks Leila

[@LeilaGharani]

You're very welcome!

[@jean-philippehenry5805]

Thank you for explaining us this very interesting feature of Excel. In addition, let me also thank you for your very clear elocution which makes it very comprehensible for those of us who are not English native speakers.

[@ecsjr]

It's was good video. Thanks a lot. Cause I learned a lot from your videos... 😘😘😘

[@LeilaGharani]

You're very welcome. Glad you like the video.

[@ecsjr]

@@LeilaGharani 🌹💐😘 thank you very much..

[@masammanam8003]

Hi This form data entry is good but I want to know, we can add a drop down list in this form or not? If can explain how. Thanks for your videos, it's very helpful to me learn.

[@LeilaGharani]

For drop downs you'd have to use VBA.

[@masammanam8003]

@@LeilaGharani ok, thanks for your support

[@ABG_7]

As always...Leila the real MVP It's hard to find a good reason to learn VBA in depth

[@leonardoggy]

You just blew my mind. I'm throwing away all the input forms I had made in VBA. :P Thank you for providing this information!

[@artyafridi]

MAY GOD LIVE YOU LONG LIFE

[@TheRolfenize]

Hi Leila, Thank you for your videos. Question: How do you create a button that would open the data entry form? (let's say, above a table?) This would make it even more user-friendly for the people not having the form function in their ribbon.

[@LydiaBrooksRealtor]

You can add it to your quick tools ribbon

[@GrahamSchroder]

Thanks Leila, You just saved me a ton of work in 6 minutes and 21 seconds. Very clearly presented.

[@LeilaGharani]

Great to hear, Graham!

[@deepakadroja6065]

Since long I was searching this type of facility in excel. As I had little knowledge of DBase. Thanks for this knowledge.

[@phanindragaddam7607]

How can I open form by default with out letting user to see the table behind?

[@handypreneur5101]

For Mac users running Excel 2019, save yourself some time as this feature is not available in the latest release. Yay! JK. Bummer.

[@CatGreenfield]

I can't find it in Excel 2018, either :(

[@justiceanderson8281]

Or 365 - unless I'm missing it.

[@daniellyons6269]

:(

[@mhaiijabines2339]

same hereeee there's no "FILE" tab :(

[@topmusicco]

thanks @handypreneur - 👍 helpful comment, I couldn't work this on Mac excel either

[@neldopardoyuvero5181]

I recently found your channel and every single video is a treasure. You're amazing!!! Thanks

[@LeilaGharani]

Wow, thank you!

[@paulodey6825]

I am super excited, i have just learnt how to create a data entry form in Excel. Thanks a million

[@filmpjesvansab]

Hi Leila, thank you for your great instructions on this subject! I have my own simple form working, but I also have a question about it. When adding data in the form, my number of characters seems limited to 245. This is not a problem when typing in the table cell outside of the form. Do you perhaps have a solution for this? Thanks again!

[@michaeld9178]

Leila, is it possible to have a drop down menu in on of the cells, eg a Status cell with only three options, Received, submitted, approved, as an example. Regards.

[@RedCloudServices]

I also would like to know if this is possible. Leila?

[@GatsbyDen041]

Yes you can. Use data validation,but first you have to create a table with the 3 options.

[@mskiara18]

I express my thanks for creating this tutorial. This is immensely helpful!

[@HP-om8cu]

You are simply awesome at teaching excel , Thanks from INDIA

[@LeilaGharani]

You are most welcome

[@dodgecarlincila879]

Thanks for this. How about if i want to hide or minimize my excel spreadsheet and just show the form for people to input their information, is it possible?

[@SoulTrain101]

Easier way: Use a Google form for data input, then connect it to a Google sheet. People will only see the form, but you'll have the data in the sheet.

[@asheshdas1843]

Brilliant..

[@evandro6707]

Leila you're the best MS Excel tutor!

[@k3bnm.229]

this just saved me from a lot of vba coding for combobox. thank you!!

[@LeilaGharani]

You're welcome!

[@ahmedatef9518]

I can’t find “Form” in all commands list, any idea? I have latest excel

[@BINAdelAhmed]

Ahmed Atef Not in “All commands” It is in “commands not in the ribbon”

[@shfsp]

@@BINAdelAhmed i cant find it on mac man.

[@topmusicco]

@@shfsp it appears Mac Excel versions don't include Form as an option, so this advice only works for PCs

[@sedarathnadcd]

With a limited time, you provide all information, well done

[@laurentcyr6983]

Thank you so much for your work! I was looking for intermediate to advanced lessons on Excel... and then I found your channel! Life is good :-)

[@gabrielrichard6007]

You are the best excel Tutor I ever encountered

[@jacquesvolkerts9794]

Incredible! After years of playing with Excel I learned in 5 minutes quite a useful application of userforms. And that by a most elegant Pro. Thank you Leila Gharani.

[@LeilaGharani]

My pleasure Jacques. Glad you found something useful.

[@philhemstock]

Oh dear god!! How have I never come across this before?! Thank you so much 🤩

[@Sox_girl]

OMG!!! I WISH I WOULD HAVE KNOWN ABOUT THIS LONG AGO - LOL. Leila you have made my day! I have a huge excel data sheet which I am working to modify for ease and you just made my life easier. Thank you!!!!

[@LeilaGharani]

Wonderful Laura!

[@SWSW560]

Ahhhh, my favorite Excel Teacher. Good morning Ms. Gharani .

[@bongzsmalawu1614]

I am your regular follower, thank you for this, I had already learnt VBA forms, this seems very handy that VBA

[@MrSavindrasingh]

I was under a wrong impression that I know Excel very well. You earned a subscriber.

[@LeilaGharani]

With Excel there is always something new to learn :) Glad to have you here.

[@victorwilliams4403]

Very helpful and informative. THANKS.

[@vijayarjunwadkar]

Thanks for another great tip! Every time I browse your channel, I chance upon something that makes me better in Excel!

[@LeilaGharani]

My pleasure Vijay. Glad to help.

[@jonathanwieler8863]

I’m SO glad I found your channel! Thank you for making all these videos! They are very helpful!

[@LeilaGharani]

Glad you like them, Jonathan!

[@thierryfortin7301]

Hi Leila, Top cette vidéo, comme toutes les autres d'ailleurs !!!! Les nouvelles des usa ne sont pas rassurantes, fais attention à toi et à tous tes proches pretty Princess!♥️

[@jawahardurairaj]

Thank you Leila for the video. This functions of excel could be used without any additional training in Excel

[@JD4x413]

I have used Excel for years and today you amazed me 😱

[@LeilaGharani]

I'm glad I was able to surprise you :)

[@fuzzylon]

Thank you for showing us this. I had a feeling there would be a way to do this, but I couldn't figure out how, I hadn't realised it was hidden away the way that it is

[@congnghevakythuat]

Thank you! I also have a video on how to create an input form using excel. But with another solution. Welcome to watch! Thanks

[@kevinbarnett9487]

Amazing. You are a very good communicator in addition to your Excel expertise. Thank you!

[@ismailabdelghany2234]

you're always shining and your videos are amazing.

[@N7eptune]

Leila you left out the best part! Forms are limited to 32 columns and you can get around this by hiding columns. Interestingly if you are using your table as a source for a mail merge the hidden columns will still be visible in your mail merge. 255 columns is the limit for a mail merge. (My forms work even if my spreadsheet isn't a table and I did manage to add a form to my ribbon somehow.)

[@ulludacharkha]

Most Useful Comment. BTW, how did you added the Form to the Ribbon ?

[@N7eptune]

​@@ulludacharkha In my Office 365 a Form has been added to my Data Tab Ribbon and I also have made another Tab called Form and added it there. If you Right click on a Ribbon it will give the option to customize the ribbon. It is a matter of sifting through the options to find what you want to add. Hope this incomplete explanation helps. (Usually, the Form sits in the Quick Access Toolbar where it is possible to Right click on an icon to access the options menu.)

[@rabcatz9013]

I've subscribed and followed your channel. You're my savior!

[@LeilaGharani]

Welcome aboard!

[@kurtjohnson1341]

I'm all over this one! My work just got 100 times easier!

[@LeilaGharani]

Great to hear that, Kurt!

[@caguinagaldi]

Chama tú no solo eres "a great teacher", estás cheverísima también. Thanks for your tips.

[@2White2Cloud2]

Te está matando el queso jajaja.

[@nikhilbhatia163]

I wish I have found your channel sooner missed a lot of good stuff about excel. Having fun learning new things.

[@rajivkwt]

Excellent suggestion Laila and till now I thought we have to use VBA for making forms in excel

[@theothersideofjaselees.c.432]

This is so awesome! I will definitely try doing this to make my encoding even better! Thanks Leila!

[@randallklein3271]

Excellent presentation. Clear. Concise. Easy-to-follow. Thanks.