Using full names in dropdown list

G'day PabloV,

If I've understood you correctly, that you want spacing in the data validation (dropdown box).

You want the dropdown box to look like this (for example)

Americas
Asia & Pacific Region
Europe, Middle East & Africa

Your group name is, Regions and the range is Z1:Z3
Americas
AsiaPacificRegion
EuropeMiddleEastAndAfrica

Put the new look list you want the at Y1:Y3

Col Y                                           Col Z
Americas                                     Americas
Asia & Pacific Region                     AsiaPacificRegion
Europe, Middle East & Africa           EuropeMiddleEastAndAfrica

Now change the cell range of 'Regions' to the new look list (Y1:Y3)
Then in the data validation at cell J4 change =INDIRECT(I4) to

=INDIRECT(VLOOKUP(I4,X1:Z3,2,FALSE))

Remember to enter your cell reference to suit your data layout.

HTH