Naming Groups Of Data

When you work with large amounts of data it is often useful to identify the groups of cells by naming them. The way you can do it is first to:

1. Select a range of cells that you want to name and that are related to each other.
2. Go to the Name box on the left of the formula bar, Type whatever you want to name it.

Editing

1. Go to the Formulas Tab and in the defined groups click the Name Manager.
2. A dialog box appears click on the name that you gave it
3. You can edit the cell range in the Refers to button and after going to the edit click ok.
4. It closes and it takes you back to the Name Manager dialog box and just click close and you are done.