Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a named range for 3 cells in excel 2003 I need to insert 1 more cell into this named range

how do I achieve this in excel 2003

share|improve this question
up vote 2 down vote accepted

Insert > Name > Define Find the name in the list, click on it and then change the definition in the "relates to" box (so in you rcase change the row or column number to increase the range) Click OK to finish

share|improve this answer
thanks it worked! – balalakshmi Mar 25 '10 at 10:45

For Office 07, click on the Formulas tab, then "Name Manager".
You should now see a list of all named ranges you have in this workbook.
Click on any one of them and you can change the range at the bottom (don't forget to save)


share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.