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.
Not to be confused with Dyer, Tennessee. Dyer County is a county located in the westernmost part of the U.S. state of Tennessee. As of the 2010 census, the population was 38,335. Its county seat is Dyersburg. Dyer County comprises the Dyersburg, TN Micropolitan Statistical Area.