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.
Illinois' first state capitol was located in Kaskaskia, but in 1820 the state decided that it should be moved. Carlyle lost to Vandalia by one vote. In 1824, the State of Illinois created Clinton County by carving it out of Washington, Bond, and Fayette counties. Carlyle was to be the county seat should land be donated for this purpose. Charles Slade donated 20 acres (8.1 ha) of property so that the county seat would be located in Carlyle.