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. For Excel 2010 to 2016 users click Define Name. 2  From the menu, select Apply Names.  From the Apply Names dialogue box, select the Name you want and click OK:
Sponsored Topics. Dwight is a village in located mainly in Livingston County, Illinois, with a small portion in Grundy County, Illinois. The population was 4,260 at the 2010 census. Dwight contains an original stretch of the famous U.S. Route 66, and uses a railroad station designed in 1891 by Henry Ives Cobb.
Homefacts City Report. Crystal Lake is located in Mchenry County, IL. The population is 40,269, making Crystal Lake the largest city in Mchenry County. There are 17 public schools in Crystal Lake with an average Homefacts rating of A-. The total crime rate for Crystal Lake is low, and there are 25 registered sex offenders residing in the city.