98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Naming Ranges
Naming Ranges
Resolved · Medium Priority · Version 2003
Wed 17 Jun 2009, 16:07Delegate 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:09Trainer 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 information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Do a fast scrollIn big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle. |
