Hessel de Walle's Blog

In Excel you can validate a cell through Data  =>  Data Validation . We then will get this window: At  Allow  we then can choose List and then at  Source  we pick the range where the data are . Want we want to do here is select a continent first and then automatically restrict the choice in the next cel to countries from the specific continent. In the example we see the data (in Dutch) which we are going to use in our example, A1:E6 : afrika amerika australië azië europa nigeria brazilië nieuw zeeland china nederland boeroendi argentinië australië japan belgië liberia equador nieuw guinea thailand polen sierra leone peru pakistan duitsland mauretanië bolivia india engeland We will use names here to make the stepped choices work. We select  A1:E6 . We then choose the tab  Formulas  and  then Create From Selection . We'll get: Here we check the upper box only. Then we click OK . We now created five name...