![]() You can also view/edit/delete your Named Range by going to the Formulas tab in the Ribbon menu and selecting Name Manager. In our example, we will give this a name of StockList. You can view your Named Range by clicking on the drop-down box in the Name Box. STEP 2: In here you can name your range whatever you like (make sure there are no spaces) and press Enter. STEP 1: To define a Named Range in Excel you need to select the cell/cell range/Table/function/constant and go to the Name Box which is located on the top left-hand corner of the workbook – next to the Formula Bar.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |