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.
McCordsville is located in the northwest corner of Hancock County just south of Geist Reservoir, bordering both the City of Lawrence in Marion County and the Town of Fishers in Hamilton County. We are conveniently located off of State Highway 67 and less than 10 minutes from I-70, I-69, I-465 and SR 234.