•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
When will Excel nut up and allow table columns to be used as data validation drop-down lists?
We've been stuck using the two workarounds for ages: the "named range" trick, and the "INDIRECT()" trick. Although the named range trick is a bit more flexible and the INDIRECT() trick seems more intuitive, none are ideal.
I recently used Google Sheets and realized HOLY HELL you can just set the value for a data validation range to a table column!
This made me think back to that "what are the advantages of Google Sheets" thread from the other day and realize, what is Excel waiting for? It obviously can be implemented with no problems, so what gives?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#google sheets