Forum home » Delegate support and help forum » Microsoft Excel Training and help » Naming Ranges

Naming Ranges

ResolvedVersion 2003

Wed 17 Jun 2009, 16:07 Delegate David said...

David has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Naming Ranges

If you have named a range say A2:A5 and you want to extend it A7 do you have to delete the range and re-do it A2:A7 or can you edit it

Thu 18 Jun 2009, 09:09 Trainer Carlos said...

RE: Naming Ranges

Hi David

You can edit any range previously created. To do this:

1. Select the Insert menu and then select Name
2. Click Define in the sub menu
3. The Define name dialog box appears
4. Select the Name to be edited
5. Change its address in the Refers to: area
6. Click OK

The Name will now refer to the new range

Hope this helps

Carlos

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.

View all Excel hints and tips

Naming Ranges

Naming Ranges

RE: Naming Ranges

Excel articles

Excel tip:

Sum Up All the Values in A Column