How to Make a List of 1 to 100 in Excel

[@ashnidindoyal]

Thanks bro, it really helped alot 😊

[@Excel10tutorial]

You're welcome! Let me know if you have any other Excel questions.

[@philrichardson2654]

Great Tip - Especially the last one - that's a new one for me and I'll use from now on - Tks for Sharing!

[@Excel10tutorial]

I'm glad you like it. Please share and be with us

[@johnboffin476]

Hello Master, I am building a spreadsheet with 7 columns and 1200 rows. Column A is just a reference column, B is dates column which are fine, column C is with Validation drop down codes list, column D is products details with drop down, tested and working all down to 1200 rows. Column E is payments F is Income and G is balance (Balance column work as it should) now I need your input in column E and F, If I select from column C for Income code it should only allow me the income column F and if selected payment from column C codes it should allow me to enter in payments column E. In income column I have 5 source of income and payments I have about 44 or it may grow prior (My code list and details list grows as it should). I need help using validation (Custom) in these two Column E & F, so that the entry don't get switched between two columns. Thanks a lot if you could help.. (I use Excel 2000) Please reply if you can't.

[@Excel10tutorial]

Are you looking for this one? kzbin.info/www/bejne/oJe6oYWXobScrK8