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.
Hartsville is a town in Trousdale County, Tennessee, United States. It is the county seat of Trousdale County, with which it shares a consolidated city-county government. The population of Hartsville was 2,369 as of 2010. Hartsville now shares with Trousdale County a consolidated city-county government by virtue of a referendum which passed in Trousdale County in 2000. Despite the city-county government, under Tennessee law, Hartsville is also considered to be a distinct municipality.