click Use in Formula, and then select the desired name. Begin typing the name in the formula, select a name from the AutoComplete list, and use the arrow keys and Tab key to enter the name in the formula. Begin typing the formula, and then click and drag with the mouse to select the cells to include in the formula. Right-click one of the cells in the range. just that that applyes Thanks