Make sure to Leave a comment on the video to share your thoughts on this. Do let me know if you have this feature in your Excel. And which Excel version you are using?
Only available in MS 365. You don't need the validation data list in a table, for the drop down list simply go, say ten rows past the last entry in the validation list, the blanks will not show in the drop down list, but when you enter a new category it will update the drop down list.
Make sure to Leave a comment on the video to share your thoughts on this. Do let me know if you have this feature in your Excel. And which Excel version you are using?
Thanks for sharing🙂
My pleasure 😊
Thank you very much! I'm using 2010 at home, 2013 at job 1 & the latest at job 2, so I'll definitely get to use these tips at some point. 😁
Great to hear this
Thanks for the video. I have Microsoft 365 and this feature is included. It certainly has potential!
Yes it does!
Thanks for sharing.
Thanks for watching!
Great function. I have office 365 and I have received this update.
Great
Am having Excel 2016. I do have this feature.
Awesome
How to work in 2007 excel
It will not, you need to have Microsoft 365.
Yeah.
Only available in MS 365. You don't need the validation data list in a table, for the drop down list simply go, say ten rows past the last entry in the validation list, the blanks will not show in the drop down list, but when you enter a new category it will update the drop down list.
yes