![]() In this example, the range is automatically set to =Sheet1!$A:$A because this is the range of cells that we previously highlighted. 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. This Excel tutorial explains how to define a named range in Excel 2011 for Mac (with screenshots and step-by-step instructions).
0 Comments
Leave a Reply. |