being lazy also, I would probably insert a row of cells just below the first
row of cities
copy the first row and paste into this second row
then in the first Cell enter "Other" and copy across the 50 columns.
this will have the Other as the first entry in the column.

If you have an equal number of cities in each column, you could do
something similar to put them with Other as the bottom entry

If you have your cities sorted alphbetically and want to have the "other" as
the bottom one
use ZZZ as your entry, do a sort on each column and use a global
find ZZZ replace with Other


"BB" wrote:

OK so I have a worksheet with a drop-down list that has the states of the US
listed. In the next column are 50 dependant drop down lists that have various
cities listed, and depending on which state you choose, the drop down list of
that state's cities shows.

Is there any way I can include the option "Other" in the cities column (call
it column B) without going back to my list source (my list is a named range)
and typing in "other" in the lists of each of the 50 states. I am a little
too lazy to do all that if I don't have to.

Thank you for your time