Link to home
Start Free TrialLog in
Avatar of mlagrange
mlagrangeFlag for United States of America

asked on

Arranging data validation lists

Hello - I have inherited a data entry spreadsheet that has a hidden tab festooned with dozens of lists for data validation

The person that laid them out originally started at A1, pasting in these small (and sometimes large) lists, and then when that extended past the viewable area of the screen, they would start the next list in B1,work their way down with multiple lists, and so on.

So now they are telling me there are a lot of updates to the individual lists, and I'm sure some of them are going to involve inserting a row that is going to cause gaps in the columns that intersect

I'm an Access developer; this is my first Excel thing. I'm assuming I'm in for it, re-arranging all these lists.

What is the common wisdom on arranging data validation list sources to where they are easily maintained?

Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Had there been a few lists I think that the vertical lists would have been just fine. But considering numerous lists then probably horizontal lists would be a better choice where you can indefinitely add to the lists.
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mlagrange


YES! I thought there might be a better solution then re-arranging all those things!