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.
Charles Slade pushed hard for Carlyle to become the state capital of Illinois, but lost by one vote to Vandalia in 1819. In 1824, Clinton County was formed, and Carlyle became the county seat in July 1825, both at the initiative of Charles Slade.