You can also force Excel to name a range based on data you already have in your worksheet. Select the range you want to name, and in the Formulas tab on the ribbon, click "Create From Selection." ...