Then in the 'Refers to' box, enter the range of cells that the name applies to. In this example, we've entered Order_ID as the name for the range.
The name can be up to 255 characters in length. When the Define Name window appears, enter a descriptive name for the range. Under the Insert menu, select Name > Define. In this example, we've selected all cells in column A. To add a named range, select the range of cells that you wish to name. Question: In Microsoft Excel 2011 for Mac, how do I set up a named range so that I can use it in a formula?Īnswer: A named range is a descriptive name for a collection of cells or range in a worksheet. If you want to follow along with this tutorial, download the example spreadsheet.
