To apply your new Name, click into cell B5 where your formula is, and do this: 1  On the Named Cells panel, Click Name a Range. 2  From the menu, select Apply Names.  From the Apply Names dialogue box, select the Name you want and click OK:
Dyersville is a city in eastern Delaware and western Dubuque counties in the U.S. state of Iowa. It is part of the Dubuque, Iowa, Metropolitan Statistical Area. The population was 4,058 at the 2010 census, up from 4,035 at the 2000 census.
Clarksville is a town in Clark County, Indiana, United States, along the Ohio River and is a part of the Louisville Metropolitan area.