Рет қаралды 131,531
In this video we answer a common problem people have when creating dependent drop down lists in Excel. And that problem is when your list items contain spaces.
This question has been asked of me many times since creating my dependent drop down lists video - • Create Dependent Drop ...
And my multiple dependent drop down lists video - • Create Multiple Depend...
To create these lists we need to set up named ranges. However named ranges do not allow the use of spaces in a name.
So how can we still use this technique? If the named range does not have a space, but the item on the worksheets does. This video shows you how.
Master Excel today with this comprehensive course - bit.ly/Ultimat...
Find more great free tutorials at;
www.computerga...
** Online Excel Courses **
The Ultimate Excel Course - Learn Everything ► bit.ly/Ultimat...
Excel VBA for Beginners ► bit.ly/37XSKfZ
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2Siivkm
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1