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.
It was formed in 1796 from part of Tennessee County and is bordered by the Tennessee counties of Stewart, Houston, Dickson, Cheatham and Robertson on three sides, and by the Kentucky counties of Christian and Todd on the fourth side. Clarksville, the county seat, is at the confluence of the Cumberland and Red Rivers. The county is 540 square miles, with the elevation ranging from 325 to 575 feet above sea level and averaging 500 feet.