SUPER EASY Excel Data Entry Form (NO VBA)

Поделиться
HTML-код
  • Опубликовано: 30 окт 2024

Комментарии • 1,9 тыс.

  • @LeilaGharani
    @LeilaGharani  Год назад +5

    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
      @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?

  • @Wintershot11
    @Wintershot11 3 года назад +71

    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!

  • @arnelaguha8356
    @arnelaguha8356 3 года назад +16

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

  • @ckokse
    @ckokse 5 лет назад +439

    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
      @LeilaGharani  5 лет назад +30

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

    • @jennifer7685
      @jennifer7685 5 лет назад +10

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

    • @kgfes
      @kgfes 5 лет назад +9

      @@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
      @ouraniagrimes2731 5 лет назад +2

      @@jennifer7685 Me too!!!

    • @name1927
      @name1927 5 лет назад +2

      very useful

  • @sguchait
    @sguchait 5 лет назад

    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
      @LeilaGharani  5 лет назад

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

    • @sguchait
      @sguchait 5 лет назад

      @@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
      @LeilaGharani  5 лет назад +1

      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.

  • @Mandelbrot567
    @Mandelbrot567 5 лет назад +6

    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
      @LeilaGharani  5 лет назад +2

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

    • @Mandelbrot567
      @Mandelbrot567 5 лет назад

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

  • @briannakingsley360
    @briannakingsley360 4 года назад +12

    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!

  • @MareeTeolanafo
    @MareeTeolanafo 4 года назад +20

    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.

  • @jackzouyuquan9094
    @jackzouyuquan9094 3 года назад

    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

  • @مقدادحديد
    @مقدادحديد 5 лет назад +80

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

    • @LeilaGharani
      @LeilaGharani  5 лет назад +11

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

  • @crazygoat5321
    @crazygoat5321 3 года назад

    Ma’am, I have only recently discovered you RUclips 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

  • @JAFFER3657
    @JAFFER3657 5 лет назад +116

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

    • @LeilaGharani
      @LeilaGharani  5 лет назад +6

      I'm very happy to hear that Syed!

    • @ifaniabu
      @ifaniabu 4 года назад

      @@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
      @stewartdahamman2472 3 года назад

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

  • @susanmorris1007
    @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!

  • @ryanjohanides5347
    @ryanjohanides5347 5 лет назад +17

    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
      @PHWiest 3 года назад +1

      Alt, D, O

  • @satinderhayer7825
    @satinderhayer7825 3 года назад +2

    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.

  • @SalehCh
    @SalehCh 4 года назад

    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.

  • @ScottAnders62
    @ScottAnders62 5 лет назад +8

    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
      @shadrackawunyo7786 5 лет назад +1

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

  • @computerdoctorshow1470
    @computerdoctorshow1470 3 года назад

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

  • @rashidazzan36
    @rashidazzan36 5 лет назад +11

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

  • @sternritter9788
    @sternritter9788 9 месяцев назад

    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!

  • @VictorLeva
    @VictorLeva 4 года назад +4

    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.

  • @deepakadroja6065
    @deepakadroja6065 3 года назад

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

  • @fredericktruter5292
    @fredericktruter5292 5 лет назад +7

    Always something new to learn, thank you.

    • @LeilaGharani
      @LeilaGharani  5 лет назад

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

    • @fredericktruter5292
      @fredericktruter5292 5 лет назад

      @@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
      @LeilaGharani  5 лет назад

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

  • @threeaxis359
    @threeaxis359 3 года назад

    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.

  • @excelisfun
    @excelisfun 5 лет назад +38

    Thanks for the Old School Excel Fun!

    • @LeilaGharani
      @LeilaGharani  5 лет назад +12

      Old school is the Fun School :)

    • @excelisfun
      @excelisfun 5 лет назад +4

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

    • @purvisinghraghav1910
      @purvisinghraghav1910 3 года назад

      HI IAM PURVI I LOVED THIS VEDIO

    • @temayet2270
      @temayet2270 3 года назад

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

    • @Aboulchad002
      @Aboulchad002 3 года назад

      Clash of the titans.

  • @jimmyta5092
    @jimmyta5092 3 года назад

    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.

  • @johnmccormick2883
    @johnmccormick2883 4 года назад +18

    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
      @pietrobissolati5882 3 года назад

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

    • @pippyfari
      @pippyfari 3 года назад +1

      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
      @johnmccormick2883 3 года назад +1

      @@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
      @pippyfari 3 года назад

      @@johnmccormick2883 Thanks brother

  • @konsamprincesingh7763
    @konsamprincesingh7763 4 года назад +1

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

  • @JoseRivera-jt5ek
    @JoseRivera-jt5ek 4 года назад +4

    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!!!

  • @shelleycrooks2119
    @shelleycrooks2119 4 года назад

    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!

  • @nonsoamamchukwu9598
    @nonsoamamchukwu9598 5 лет назад +5

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

  • @ABG_7
    @ABG_7 2 года назад

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

  • @mohamedsafeer3850
    @mohamedsafeer3850 5 лет назад +6

    You are genius

  • @waridkarachi
    @waridkarachi 4 года назад +1

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

  • @simdog635
    @simdog635 5 лет назад +5

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

    • @LeilaGharani
      @LeilaGharani  5 лет назад

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

  • @jawahardurairaj
    @jawahardurairaj 3 года назад

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

  • @pradhanbalter3796
    @pradhanbalter3796 4 года назад +9

    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!

  • @victorwilliams4403
    @victorwilliams4403 4 года назад +1

    Very helpful and informative. THANKS.

  • @mgtubb
    @mgtubb 4 года назад +3

    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.

  • @mskiara18
    @mskiara18 Год назад

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

  • @masammanam8003
    @masammanam8003 5 лет назад +5

    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
      @LeilaGharani  5 лет назад +1

      For drop downs you'd have to use VBA.

    • @masammanam8003
      @masammanam8003 5 лет назад

      @@LeilaGharani ok, thanks for your support

  • @alainndayiragije5503
    @alainndayiragije5503 4 года назад

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

  • @lorrimdavis
    @lorrimdavis 5 лет назад +9

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

    • @LeilaGharani
      @LeilaGharani  5 лет назад +2

      Even these simple things can be quite useful sometimes :)

  • @evandro6707
    @evandro6707 3 года назад

    Leila you're the best MS Excel tutor!

  • @ChristianAndreassen
    @ChristianAndreassen 5 лет назад +4

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

  • @gabrielrichard6007
    @gabrielrichard6007 2 года назад

    You are the best excel Tutor I ever encountered

  • @TheRolfenize
    @TheRolfenize 3 года назад +3

    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.

    • @Write4Community
      @Write4Community 2 года назад

      You can add it to your quick tools ribbon

  • @bongzsmalawu1614
    @bongzsmalawu1614 Год назад

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

  • @DocBizzle
    @DocBizzle 5 лет назад +3

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

    • @efeveesse
      @efeveesse 4 года назад

      So do I. Her tips are awesome as well 😁

  • @rajivkwt
    @rajivkwt 3 года назад

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

  • @batarasiagian9635
    @batarasiagian9635 5 лет назад +4

    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
      @LeilaGharani  5 лет назад +1

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

  • @herwigsyen804
    @herwigsyen804 4 года назад +1

    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
      @LeilaGharani  4 года назад

      It's great you could already implement it.

  • @filmpjesvansab
    @filmpjesvansab 4 года назад +4

    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!

  • @sedarathnadcd
    @sedarathnadcd 2 года назад

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

  • @michaeld9178
    @michaeld9178 5 лет назад +6

    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
      @RedCloudServices 5 лет назад

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

    • @GatsbyDen041
      @GatsbyDen041 6 месяцев назад

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

  • @afrasnawfer6118
    @afrasnawfer6118 3 месяца назад

    Allah reward you for this most useful video. Very clear and easy explanation.

  • @phanindragaddam7607
    @phanindragaddam7607 5 лет назад +15

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

  • @ismailabdelghany2234
    @ismailabdelghany2234 3 года назад

    you're always shining and your videos are amazing.

  • @artyafridi
    @artyafridi 5 лет назад +5

    MAY GOD LIVE YOU LONG LIFE

  • @neldopardoyuvero5181
    @neldopardoyuvero5181 3 года назад

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

  • @handypreneur5101
    @handypreneur5101 5 лет назад +24

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

    • @CatGreenfield
      @CatGreenfield 4 года назад

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

    • @justiceanderson8281
      @justiceanderson8281 4 года назад

      Or 365 - unless I'm missing it.

    • @daniellyons6269
      @daniellyons6269 4 года назад

      :(

    • @mhaiijabines2339
      @mhaiijabines2339 4 года назад

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

    • @topmusicco
      @topmusicco 4 года назад

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

  • @JD4x413
    @JD4x413 5 лет назад

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

    • @LeilaGharani
      @LeilaGharani  5 лет назад

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

  • @dodgecarlincila879
    @dodgecarlincila879 4 года назад +3

    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
      @SoulTrain101 4 года назад

      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.

  • @ummernani
    @ummernani 4 года назад

    Hai Leila your excel videos are very very useful in my life

  • @asheshdas1843
    @asheshdas1843 5 лет назад +4

    Brilliant..

  • @jean-philippehenry5805
    @jean-philippehenry5805 2 года назад

    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.

  • @johnbrown7998
    @johnbrown7998 Год назад

    So Straight forward and concise, thank you

  • @fuzzylon
    @fuzzylon 2 года назад

    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

  • @jessicaverstegen4547
    @jessicaverstegen4547 2 года назад

    Great, clear and fast explanation. Thank you

  • @hemantmehta5470
    @hemantmehta5470 5 лет назад

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

  • @leonardoggy
    @leonardoggy 3 года назад

    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!

  • @veronicagida2397
    @veronicagida2397 4 года назад

    Thanks, you've been very helpful lately. I just started watching your videos
    Please continue sharing 💞

  • @jonathanwieler8863
    @jonathanwieler8863 2 года назад

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

  • @philhemstock
    @philhemstock 3 года назад

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

  • @SWSW560
    @SWSW560 2 года назад

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

  • @HP-om8cu
    @HP-om8cu 4 года назад

    You are simply awesome at teaching excel , Thanks from INDIA

  • @ranithaperera324
    @ranithaperera324 2 года назад

    Very useful lesson ....
    Thanks a lot ..... Madam
    Ranitha from 🇱🇰

  • @billbreaker1680
    @billbreaker1680 3 года назад

    Thank you Leila! This is useful stuff even in 2021!!

  • @JamesErvinBerry
    @JamesErvinBerry Год назад

    Perfect! This has answered my questions! Great job!

  • @kossiviaglee2997
    @kossiviaglee2997 4 года назад

    So helpful, please don't stop! thanks

  • @thangaveluraj5366
    @thangaveluraj5366 4 года назад +1

    Super useful presentation n excellent voice,

  • @corvoogel2137
    @corvoogel2137 2 года назад

    I love your video and the way you explain it. Needed this option badly... thanks again

  • @Chucketh
    @Chucketh 2 года назад

    Thank you for another great and quick walk through!

  • @dilipwarrier5199
    @dilipwarrier5199 4 года назад +2

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

  • @rabcatz9013
    @rabcatz9013 3 года назад

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

  • @rangpurtax-vatexcelsolutio1091
    @rangpurtax-vatexcelsolutio1091 3 года назад

    Excellent your teaching Capacity. i have learned from you in huge subject.

  • @k3bnm.229
    @k3bnm.229 2 года назад

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

  • @shirazalikhan1957
    @shirazalikhan1957 Год назад +1

    HELP FULL VIDEO

  • @Timurlane100
    @Timurlane100 2 года назад

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

  • @jamietan8002
    @jamietan8002 3 года назад

    Yes, i re-viewed the video and realised this is good for the excel to mail marge. Usually long horizontally

    • @ulludacharkha
      @ulludacharkha 3 года назад

      Hi Jamier, Can you explain how this is good for the mail merge ?

  • @ericonchangu7830
    @ericonchangu7830 5 лет назад

    I have been manually filling in data but this now changes the way I do things.

  • @algupt7385
    @algupt7385 3 года назад

    Simply Learn .. Very Nicely Presented 5 Starts

  • @azis7281
    @azis7281 3 года назад

    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.

  • @mdtausifiqbal
    @mdtausifiqbal 4 года назад

    Every time when I see your video i learn something new. thanks for sharing this hidden features of this excel.

  • @asadullah24
    @asadullah24 2 года назад

    when I Watching this video Solve my All problem thank miss really Usefully

  • @jeevz3892
    @jeevz3892 4 года назад

    At 11th second of your video i subscribed your channel . Very professionally done 🤞🏻. Please keep moving ✨

  • @azizahmadzaheer5827
    @azizahmadzaheer5827 3 года назад

    Leila you are awesome, thank you so much it made my work very easy. Keep continue posting such easy and useful videos please. Bless you.

  • @chavelooo33
    @chavelooo33 4 года назад

    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.

  • @GrahamSchroder
    @GrahamSchroder 4 года назад

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

  • @vickylakhwani
    @vickylakhwani 5 лет назад

    You are genius ma'am in excel.