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?
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!
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!!
I've been using Excel off and on since 2000. Your tutorials and courses go into way more depth than the training I took in high school and university 20+ years ago. Granted, Excel wasn't as intricate back then as it is today. I recently enrolled in your Black Belt package and finished your Essentials course. I'm close to finishing your Advanced Excel course. While I don't consider myself an expert by any means, I feel I'm well on the way there. Thanks Leila! 👍👍
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!
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 ..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...
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.
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!
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.
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
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.
@@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
Ma’am, I have only recently discovered you UA-cam 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
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!
@@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?
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.
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.
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
@@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
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.
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.
Question i have a stock journal i want to create. What i am looking to is a need a note box to type maybe lines of info such as source of stock information. How do i do that?
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!!!
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!
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.
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!
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!
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.
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?
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!
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.
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.
Hello Mam, Good to see you, I have learned many more from your videos. Whenever I see your videos must learn anything. Please tell me which Office you have and use??? Office 365 Office 2021 Office 2016 and also tell me which office you recommend ??
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!!!!
Hi, Thank you that was very easy and nice tip much appreciated. Can we lock the excel sheet and keep form and front end for entry? I have file that is edited by multiple people so avoid deleting and overwriting each other data.
I love it, well explained, simple, and also you take care of your image. The quality of your videos are high specially because you pay attention to every detail.
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.
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
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?
I got promoted in my job because of your videos. I could never have done it without these. You are great! More power!
Support her
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!
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!!
I'm glad you like it. It can really be useful.
Leila Gharani is it a new feature? I could have used this literally 40x per month for the last 11 years
@@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
@@jennifer7685 Me too!!!
very useful
I've been using Excel off and on since 2000. Your tutorials and courses go into way more depth than the training I took in high school and university 20+ years ago. Granted, Excel wasn't as intricate back then as it is today. I recently enrolled in your Black Belt package and finished your Essentials course. I'm close to finishing your Advanced Excel course. While I don't consider myself an expert by any means, I feel I'm well on the way there. Thanks Leila! 👍👍
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!
True, VBA is much more flexible. This is just an alternative that is simple and works without it.
@@LeilaGharani I agree, it is one click (form) versus maybe hours of coding. (VBA).
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.
That's what keeps it interesting. There's always new stuff to discover :)
@@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...
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.
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!
Wow, thank you Brianna!
Thanks
Thank you!
Thanks for the Old School Excel Fun!
Old school is the Fun School :)
@@LeilaGharani Sometimes... But the Old School does not have Power Query, M Code, DAX, Power Pivot or Power BI... : (
HI IAM PURVI I LOVED THIS VEDIO
thank you so much for sharing this.....
Clash of the titans.
Tack!
Thank you, Mats!
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. :)
Alt, D, O
You are the best excel Tutor I ever encountered
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.
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
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.
The people who dislike such videos, what do they want in life? I just don't understand why someone would dislike this.
😘
every time I click your videos I learn something new and that too in a very quick and professional way, Thank You :)
I'm very happy to hear that Syed!
@@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
@@LeilaGharani Have you spent time in Ireland? Because I can hear it in your accent!
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!
Do you know, Leila, you switched us from amateur to professional in Excel, thank you sweet queen. thanx
That's my mission actually! I'm happy I can contribute to your development.
Ma’am, I have only recently discovered you UA-cam 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
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!
There's always something new to learn each day in Excel.....
you're always shining and your videos are amazing.
Always something new to learn, thank you.
That's good though, right? Otherwise it would be too boring :)
@@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?
I guess you have to create your own macro/VBA code for that. I don't know of another add-in that replaces this...
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.
I love this women thank you for the much needed excel education god bless you.
Not god ALLAH
I am your regular follower, thank you for this, I had already learnt VBA forms, this seems very handy that VBA
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.
Try to hide the column(s) you don't want to show in the form. It seems to works fine......
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
@@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
@@johnmccormick2883 Thanks brother
Ive watched your video several times because i had to set up data entry forms for several customers ... nice job, thank you
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.
For drop downs you'd have to use VBA.
@@LeilaGharani ok, thanks for your support
As always...Leila the real MVP
It's hard to find a good reason to learn VBA in depth
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.
I also would like to know if this is possible. Leila?
Yes you can. Use data validation,but first you have to create a table with the 3 options.
Question i have a stock journal i want to create. What i am looking to is a need a note box to type maybe lines of info such as source of stock information. How do i do that?
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!!!
I’m SO glad I found your channel! Thank you for making all these videos! They are very helpful!
Glad you like them, Jonathan!
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!
Leila you're the best MS Excel tutor!
You are genius
Its amazing. I am not comfortable with Visual Basics. So this is kind of a useful excel trick. Thanks Leila
You're very welcome!
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.
You can add it to your quick tools ribbon
I recently found your channel and every single video is a treasure. You're amazing!!! Thanks
Wow, thank you!
For all I can say: Thank you for the simplified lesson! It was well learnt.
Glad you like it Nonso :)
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!
Glad it helped!
Another very interesting Video, I wasn't aware of this function in Excel. Thanks again
You're very welcome Steve. Glad you like the video.
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!
Thanks a lor for great video. Is this applicable to Google sheet too?
Sheets doesn't have this feature.
Great video Leila. Very useful tip - its going right into my current project :)
I express my thanks for creating this tutorial. This is immensely helpful!
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.
Very helpful and informative. THANKS.
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?
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.
Many thanks Leila, everytime I watch your Excel tutorial videos I learn something new.
Happy to hear that, Alain!
Thank you so much! It is always amazing to see these tools doing more than a "budget" :D
Even these simple things can be quite useful sometimes :)
With a limited time, you provide all information, well done
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!
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.
I love your voice! And of course, I greatly appreciate all of the awesome Excel tips you share!
So do I. Her tips are awesome as well 😁
Ahhhh, my favorite Excel Teacher.
Good morning Ms. Gharani .
How can I open form by default with out letting user to see the table behind?
I've subscribed and followed your channel. You're my savior!
Welcome aboard!
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.
You're very welcome. I'm happy you find the videos useful!
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.
MAY GOD LIVE YOU LONG LIFE
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!
For Mac users running Excel 2019, save yourself some time as this feature is not available in the latest release. Yay! JK. Bummer.
I can't find it in Excel 2018, either :(
Or 365 - unless I'm missing it.
:(
same hereeee there's no "FILE" tab :(
thanks @handypreneur - 👍 helpful comment, I couldn't work this on Mac excel either
So helpful, please don't stop! thanks
Brilliant..
Since long I was searching this type of facility in excel. As I had little knowledge of DBase. Thanks for this knowledge.
I like your teaching style, thank you!
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!
It's great you could already implement it.
Hello Mam,
Good to see you, I have learned many more from your videos. Whenever I see your videos must learn anything.
Please tell me which Office you have and use???
Office 365
Office 2021
Office 2016
and also tell me which office you recommend ??
Perfect! This has answered my questions! Great job!
Really impressive. In two days of casually watching your videos, I've learned more useful techniques than from a month-long course.
Great to hear!
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!!!!
Wonderful Laura!
Excellent suggestion Laila and till now I thought we have to use VBA for making forms in excel
You are an amazing teacher of Excel, no doubt you have great command over Excel
Hi, Thank you that was very easy and nice tip much appreciated. Can we lock the excel sheet and keep form and front end for entry? I have file that is edited by multiple people so avoid deleting and overwriting each other data.
So useful! Thank you!
That was awesomeeeee...all these years I used to waste time creating forms...this is a life saver!!! Thanks a lot, Leila!
So Straight forward and concise, thank you
Thank you Leila! This is useful stuff even in 2021!!
Super useful presentation n excellent voice,
Thanks, you've been very helpful lately. I just started watching your videos
Please continue sharing 💞
Hello madam may living God bless you more Ameen I am learning a lot from your videos. I have a question, which country are you from?
Always Awesome and helpful!
Thank you for another great and quick walk through!
thank you so much for sharing this, it helps so much and you made it so easy for us to use, so wonderful , love you! *love*
Good job! Very handy tool for a large data input.
Excellent work without waist of time.
Thank you Leila for the video. This functions of excel could be used without any additional training in Excel
Hai Leila your excel videos are very very useful in my life
Hi Leila, Thanks for the great video. Is it possible to make the form looks bigger. I'm using it in Idap and the form is too small. thanks.
I love it, well explained, simple, and also you take care of your image. The quality of your videos are high specially because you pay attention to every detail.
I appreciate that, Diego!
Leila you are awesome. I have been able to do so much with what I have learned from you. Big kiss from Portugal ...Thank you!!!
That's great. Thank you for the kind feedback.
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.
Really awesome 👍
Very useful with simple way
Awesome, Love tutorial, easy to follow and understand
Glad you liked it!
Very useful lesson ....
Thanks a lot ..... Madam
Ranitha from 🇱🇰
I have used Excel for years and today you amazed me 😱
I'm glad I was able to surprise you :)
I love your video and the way you explain it. Needed this option badly... thanks again