Name Cell or Range in Excel 2010

Two ways to name a cell or range in Excel

  • Highlight cell/range, Type the name in the Name Box



  • Go to Formula Tab ==> Defined Names Group ==> Name Manager ==> New