LearnFast.Ninja

Name a range in Excel 2010 - name a group of cells

Name cells so that you can refer to them in formulas. Select group of cells. Click Formulas then Define Name then Define Name. Write a name then click OK. Result: if you write the group name and press enter excel will select all cells in the group. When you write formulas you can use the group.

Name cells so that you can refer to them in formulas.

Step 1: Select group of cells.


Step 2: Click Formulas > Define Name > Define Name.


Step 3: Write a name then click OK.


Result: If you write the group name and press enter excel will select all cells in the group.


When you write formulas you can use the group.


Tags

excel

range group name