Go to tab "Formulas" on the ribbon Press with left mouse button on "Name Manager" button to open the "Name Manager" dialog box Press with left mouse button on the "New" button Type the reference, in this case =Table1 #Headers mass change table_array Name in VLOOKUP formula in other worksheets, eg, (=VLOOKUP (B4,Bank_03,2,FALSE)) I want to clone this worksheet to prepare 04 data I have now defined the corresponding 04 name ranges,Step 1 Go to the Defined Names group under Formulas Tab Step 2 Click the arrow button besides Define Name button, and select the Apply Names item from the drop down list Step 3 In the Apply Names dialog box, select the range names that you will apply to formulas, and click OK button Then you will see corresponding cell references in formulas are changed to its defined names
How To Use Excel Tables
