Excel Named Formulas in Ranges (Excel 2010)

Step 1: In cell A1 enter numbers down a few rows.

Step 2: In cell B1 enter Formula and autofill down column (as many rows as you will need€”this can exceed the number of cells that contain numbers in column A.

Step 3: Select Formulas †’ Define Name (in dropdown list). Type a name€”no spaces and first character must be a letter. Click Collapse Dialog button (it has a small red arrow) and select all the cells you autofilled in Step 2. Click Collapse Dialog button again then €œOK.€�

Step 4: In cell C1 enter a formula that uses the named formula defined in Step 3. Example: my formula that converts degree to radian was named €œrad.€� In cell C1 my formula is =COS(rad). Click Enter button. Now you can autofill Column C, but if you extend past the last row you autofilled in Step 2 you will get a #VALUE! Error€”even if you first increase the range of the autofill in Step 2. If you need to extend the range of the Named Formula, choose Name Manager (on Formula Tab) and extend the range in the Refers to: box.