We can apply the Define name feature to name a range across multiple adjacent worksheets in Excel Please do as follows 1 Click Formulas > Define Name to open the New Name dialog box 2 In the New Name dialog box, please do as follows (1) Type a name for this named range in the Name box; On the Formula tab, in the Defined Names group, click Define Name Or, press Ctrl F3 to open the Excel Name Manger, and click the New button Either way, the New Name dialogue box will open, where you specify the following details In the Name box, type the name for your dynamic range In the Scope dropdown, set the name's scope Define the named range you want used in your worksheet Select the cells that contain formulas Display the Formulas tab of the ribbon Click the downarrow at the right of the Define Name tool (in the Defined Names group) and then choose Apply Names Excel displays the Apply Names dialog box (See Figure 1) Figure 1
Define Name Excel Mac
