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
@tapan42539 ай бұрын
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?
@ckokse5 жыл бұрын
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!!
@LeilaGharani5 жыл бұрын
I'm glad you like it. It can really be useful.
@jennifer76855 жыл бұрын
Leila Gharani is it a new feature? I could have used this literally 40x per month for the last 11 years
@kgfes5 жыл бұрын
@@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
@ouraniagrimes27315 жыл бұрын
@@jennifer7685 Me too!!!
@name19275 жыл бұрын
very useful
@arnelaguha83562 жыл бұрын
I got promoted in my job because of your videos. I could never have done it without these. You are great! More power!
@kimanga001423 күн бұрын
Support her
@Wintershot112 жыл бұрын
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!
@MareeTeolanafo4 жыл бұрын
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.
@JAFFER36575 жыл бұрын
every time I click your videos I learn something new and that too in a very quick and professional way, Thank You :)
@LeilaGharani5 жыл бұрын
I'm very happy to hear that Syed!
@ifaniabu3 жыл бұрын
@@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
@stewartdahamman24723 жыл бұрын
@@LeilaGharani Have you spent time in Ireland? Because I can hear it in your accent!
@user-eq7dk2lk2d5 жыл бұрын
Do you know, Leila, you switched us from amateur to professional in Excel, thank you sweet queen. thanx
@LeilaGharani5 жыл бұрын
That's my mission actually! I'm happy I can contribute to your development.
@briannakingsley3604 жыл бұрын
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!
@LeilaGharani4 жыл бұрын
Wow, thank you Brianna!
@ryanjohanides53475 жыл бұрын
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. :)
@PHWiest3 жыл бұрын
Alt, D, O
@Mandelbrot5675 жыл бұрын
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!
@LeilaGharani5 жыл бұрын
True, VBA is much more flexible. This is just an alternative that is simple and works without it.
@Mandelbrot5675 жыл бұрын
@@LeilaGharani I agree, it is one click (form) versus maybe hours of coding. (VBA).
@sguchait5 жыл бұрын
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.
@LeilaGharani5 жыл бұрын
That's what keeps it interesting. There's always new stuff to discover :)
@sguchait5 жыл бұрын
@@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...
@LeilaGharani5 жыл бұрын
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.
@satinderhayer78253 жыл бұрын
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.
@ScottAnders625 жыл бұрын
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!
@shadrackawunyo77865 жыл бұрын
There's always something new to learn each day in Excel.....
@sarfarajkureshi65695 жыл бұрын
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.
@LeilaGharani5 жыл бұрын
I'm glad to hear that you find the videos useful.
@dilipwarrier51994 жыл бұрын
That was awesomeeeee...all these years I used to waste time creating forms...this is a life saver!!! Thanks a lot, Leila!
@crazygoat53213 жыл бұрын
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
@excelisfun5 жыл бұрын
Thanks for the Old School Excel Fun!
@LeilaGharani5 жыл бұрын
Old school is the Fun School :)
@excelisfun5 жыл бұрын
@@LeilaGharani Sometimes... But the Old School does not have Power Query, M Code, DAX, Power Pivot or Power BI... : (
@purvisinghraghav19103 жыл бұрын
HI IAM PURVI I LOVED THIS VEDIO
@temayet22703 жыл бұрын
thank you so much for sharing this.....
@Aboulchad0022 жыл бұрын
Clash of the titans.
@rashidazzan364 жыл бұрын
I love this women thank you for the much needed excel education god bless you.
@sarkarbadshah74994 жыл бұрын
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!
@computerdoctorshow14703 жыл бұрын
Ive watched your video several times because i had to set up data entry forms for several customers ... nice job, thank you
@nonsoamamchukwu95985 жыл бұрын
For all I can say: Thank you for the simplified lesson! It was well learnt.
@LeilaGharani5 жыл бұрын
Glad you like it Nonso :)
@JoseRivera-jt5ek4 жыл бұрын
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!!!
@herwigsyen8044 жыл бұрын
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!
@LeilaGharani4 жыл бұрын
It's great you could already implement it.
@humorous2me2 жыл бұрын
2 years later and your video is still right on time. Thank you for being my Excel coach!
@johnmccormick28834 жыл бұрын
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.
@pietrobissolati58823 жыл бұрын
Try to hide the column(s) you don't want to show in the form. It seems to works fine......
@pippyfari2 жыл бұрын
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
@johnmccormick28832 жыл бұрын
@@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
@pippyfari2 жыл бұрын
@@johnmccormick2883 Thanks brother
@fredericktruter52925 жыл бұрын
Always something new to learn, thank you.
@LeilaGharani5 жыл бұрын
That's good though, right? Otherwise it would be too boring :)
@fredericktruter52925 жыл бұрын
@@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?
@LeilaGharani5 жыл бұрын
I guess you have to create your own macro/VBA code for that. I don't know of another add-in that replaces this...
@SalehCh4 жыл бұрын
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.
@threeaxis3593 жыл бұрын
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.
@simdog6355 жыл бұрын
Another very interesting Video, I wasn't aware of this function in Excel. Thanks again
@LeilaGharani5 жыл бұрын
You're very welcome Steve. Glad you like the video.
@veilagonzalez3905 жыл бұрын
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.
@LeilaGharani5 жыл бұрын
It really is a simple solution that is often overlooked. Many thanks for the feedback. I'll consider it.
@Timurlane1002 жыл бұрын
Really impressive. In two days of casually watching your videos, I've learned more useful techniques than from a month-long course.
@LeilaGharani2 жыл бұрын
Great to hear!
@waridkarachi4 жыл бұрын
You are an amazing teacher of Excel, no doubt you have great command over Excel
@lorrimdavis5 жыл бұрын
Thank you so much! It is always amazing to see these tools doing more than a "budget" :D
@LeilaGharani5 жыл бұрын
Even these simple things can be quite useful sometimes :)
@DocBizzle4 жыл бұрын
I love your voice! And of course, I greatly appreciate all of the awesome Excel tips you share!
@efeveesse4 жыл бұрын
So do I. Her tips are awesome as well 😁
@sternritter97887 ай бұрын
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!
@LeilaGharani7 ай бұрын
Glad it helped!
@jimmyta50922 жыл бұрын
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.
@mohamedsafeer38505 жыл бұрын
You are genius
@ChristianAndreassen5 жыл бұрын
Great video Leila. Very useful tip - its going right into my current project :)
@shelleycrooks21194 жыл бұрын
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!
@jackzouyuquan90943 жыл бұрын
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
@pradhanbalter37964 жыл бұрын
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!
@batarasiagian96355 жыл бұрын
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.
@LeilaGharani5 жыл бұрын
You're very welcome. I'm happy you find the videos useful!
@azis72812 жыл бұрын
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.
@hemantmehta54704 жыл бұрын
Its very good to learn from you Leila. You Make concepts very simplified. daily I see your MS Excel Training Videos. Many Thanks Leila.
@OzduSoleilDATA5 жыл бұрын
Good stuff! That form is easy to forget about.
@LeilaGharani5 жыл бұрын
It sure is! Thank you Oz.
@VictorLeva4 жыл бұрын
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.
@alainndayiragije55033 жыл бұрын
Many thanks Leila, everytime I watch your Excel tutorial videos I learn something new.
@LeilaGharani3 жыл бұрын
Happy to hear that, Alain!
@mohammedhassan28083 жыл бұрын
You open the treasure to the common excel users, how to do maintain a table with Form without VBA
@whitecriss5 жыл бұрын
Excellent presentation, thank you very much! :)
@LeilaGharani5 жыл бұрын
You're more than welcome Cristian! Glad you like the video.
@mgtubb4 жыл бұрын
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.
@konsamprincesingh77634 жыл бұрын
Its amazing. I am not comfortable with Visual Basics. So this is kind of a useful excel trick. Thanks Leila
@LeilaGharani4 жыл бұрын
You're very welcome!
@jean-philippehenry58052 жыл бұрын
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.
@ecsjr5 жыл бұрын
It's was good video. Thanks a lot. Cause I learned a lot from your videos... 😘😘😘
@LeilaGharani5 жыл бұрын
You're very welcome. Glad you like the video.
@ecsjr5 жыл бұрын
@@LeilaGharani 🌹💐😘 thank you very much..
@masammanam80035 жыл бұрын
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.
@LeilaGharani5 жыл бұрын
For drop downs you'd have to use VBA.
@masammanam80035 жыл бұрын
@@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
@leonardoggy3 жыл бұрын
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!
@artyafridi5 жыл бұрын
MAY GOD LIVE YOU LONG LIFE
@TheRolfenize3 жыл бұрын
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.
@LydiaBrooksRealtor2 жыл бұрын
You can add it to your quick tools ribbon
@GrahamSchroder4 жыл бұрын
Thanks Leila, You just saved me a ton of work in 6 minutes and 21 seconds. Very clearly presented.
@LeilaGharani4 жыл бұрын
Great to hear, Graham!
@deepakadroja60653 жыл бұрын
Since long I was searching this type of facility in excel. As I had little knowledge of DBase. Thanks for this knowledge.
@phanindragaddam76075 жыл бұрын
How can I open form by default with out letting user to see the table behind?
@handypreneur51015 жыл бұрын
For Mac users running Excel 2019, save yourself some time as this feature is not available in the latest release. Yay! JK. Bummer.
@CatGreenfield4 жыл бұрын
I can't find it in Excel 2018, either :(
@justiceanderson82814 жыл бұрын
Or 365 - unless I'm missing it.
@daniellyons62694 жыл бұрын
:(
@mhaiijabines23394 жыл бұрын
same hereeee there's no "FILE" tab :(
@topmusicco4 жыл бұрын
thanks @handypreneur - 👍 helpful comment, I couldn't work this on Mac excel either
@neldopardoyuvero51813 жыл бұрын
I recently found your channel and every single video is a treasure. You're amazing!!! Thanks
@LeilaGharani3 жыл бұрын
Wow, thank you!
@paulodey68254 жыл бұрын
I am super excited, i have just learnt how to create a data entry form in Excel. Thanks a million
@filmpjesvansab4 жыл бұрын
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!
@michaeld91785 жыл бұрын
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.
@RedCloudServices4 жыл бұрын
I also would like to know if this is possible. Leila?
@GatsbyDen0413 ай бұрын
Yes you can. Use data validation,but first you have to create a table with the 3 options.
@mskiara189 ай бұрын
I express my thanks for creating this tutorial. This is immensely helpful!
@HP-om8cu3 жыл бұрын
You are simply awesome at teaching excel , Thanks from INDIA
@LeilaGharani3 жыл бұрын
You are most welcome
@dodgecarlincila8794 жыл бұрын
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?
@SoulTrain1014 жыл бұрын
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.
@asheshdas18435 жыл бұрын
Brilliant..
@evandro67073 жыл бұрын
Leila you're the best MS Excel tutor!
@k3bnm.2292 жыл бұрын
this just saved me from a lot of vba coding for combobox. thank you!!
@LeilaGharani2 жыл бұрын
You're welcome!
@ahmedatef95185 жыл бұрын
I can’t find “Form” in all commands list, any idea? I have latest excel
@BINAdelAhmed4 жыл бұрын
Ahmed Atef Not in “All commands” It is in “commands not in the ribbon”
@shfsp4 жыл бұрын
@@BINAdelAhmed i cant find it on mac man.
@topmusicco4 жыл бұрын
@@shfsp it appears Mac Excel versions don't include Form as an option, so this advice only works for PCs
@sedarathnadcd2 жыл бұрын
With a limited time, you provide all information, well done
@laurentcyr69833 жыл бұрын
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 :-)
@gabrielrichard60072 жыл бұрын
You are the best excel Tutor I ever encountered
@jacquesvolkerts97944 жыл бұрын
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.
@LeilaGharani4 жыл бұрын
My pleasure Jacques. Glad you found something useful.
@philhemstock2 жыл бұрын
Oh dear god!! How have I never come across this before?! Thank you so much 🤩
@Sox_girl4 жыл бұрын
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!!!!
@LeilaGharani4 жыл бұрын
Wonderful Laura!
@SWSW5602 жыл бұрын
Ahhhh, my favorite Excel Teacher. Good morning Ms. Gharani .
@bongzsmalawu161410 ай бұрын
I am your regular follower, thank you for this, I had already learnt VBA forms, this seems very handy that VBA
@MrSavindrasingh4 жыл бұрын
I was under a wrong impression that I know Excel very well. You earned a subscriber.
@LeilaGharani4 жыл бұрын
With Excel there is always something new to learn :) Glad to have you here.
@victorwilliams44034 жыл бұрын
Very helpful and informative. THANKS.
@vijayarjunwadkar4 жыл бұрын
Thanks for another great tip! Every time I browse your channel, I chance upon something that makes me better in Excel!
@LeilaGharani4 жыл бұрын
My pleasure Vijay. Glad to help.
@jonathanwieler88632 жыл бұрын
I’m SO glad I found your channel! Thank you for making all these videos! They are very helpful!
@LeilaGharani2 жыл бұрын
Glad you like them, Jonathan!
@thierryfortin73014 жыл бұрын
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!♥️
@jawahardurairaj3 жыл бұрын
Thank you Leila for the video. This functions of excel could be used without any additional training in Excel
@JD4x4134 жыл бұрын
I have used Excel for years and today you amazed me 😱
@LeilaGharani4 жыл бұрын
I'm glad I was able to surprise you :)
@fuzzylon2 жыл бұрын
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
@congnghevakythuat4 жыл бұрын
Thank you! I also have a video on how to create an input form using excel. But with another solution. Welcome to watch! Thanks
@kevinbarnett94874 жыл бұрын
Amazing. You are a very good communicator in addition to your Excel expertise. Thank you!
@ismailabdelghany22342 жыл бұрын
you're always shining and your videos are amazing.
@N7eptune3 жыл бұрын
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.)
@ulludacharkha3 жыл бұрын
Most Useful Comment. BTW, how did you added the Form to the Ribbon ?
@N7eptune3 жыл бұрын
@@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.)
@rabcatz90133 жыл бұрын
I've subscribed and followed your channel. You're my savior!
@LeilaGharani3 жыл бұрын
Welcome aboard!
@kurtjohnson13412 жыл бұрын
I'm all over this one! My work just got 100 times easier!
@LeilaGharani2 жыл бұрын
Great to hear that, Kurt!
@caguinagaldi3 жыл бұрын
Chama tú no solo eres "a great teacher", estás cheverísima también. Thanks for your tips.
@2White2Cloud23 жыл бұрын
Te está matando el queso jajaja.
@nikhilbhatia1633 жыл бұрын
I wish I have found your channel sooner missed a lot of good stuff about excel. Having fun learning new things.
@rajivkwt3 жыл бұрын
Excellent suggestion Laila and till now I thought we have to use VBA for making forms in excel
@theothersideofjaselees.c.4324 жыл бұрын
This is so awesome! I will definitely try doing this to make my encoding even better! Thanks Leila!