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 » Named range
Named range
Resolved · High Priority · Version 2003
Wed 13 Apr 2011, 15:18Delegate Nicola said...
Nicola has attended:
Excel Intermediate course
Excel Advanced course
Access Intermediate course
Access Advanced course
Named range
what is dynamic named range and how does one set it up?
Wed 20 Apr 2011, 14:39Trainer Simon said...
RE: named range
Hi Nicola,
Sorry about the delay in responding to you.
As you may know you can name a range of cells e.g. a2:a6 as countries. However if more items are added to the list you would have to redefine the named range.
If you use a Dynamic Named Range, as you add new items the range will automatically expand.
Please find the links below that will help explain:
http://support.microsoft.com/kb/830287
http://www.ozgrid.com/Excel/DynamicRanges.htm
http://www.exceluser.com/explore/dynname1.htm
I hope this helps and answers your question.
Regards
Simon
Wed 27 Apr 2011: Automatically marked as resolved.
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:Activating the formula bar with the keyboard in Excel 2010The formula bar in Excel 2010 contains a number of different formulas. However, it is time consuming to open the formula bar every time and insert the formula using the mouse. Instead, you can activate the formula bar with the keyboard. Simply press the F2 button on the keyboard then the information in the cell will expand allowing you to edit the information in the cell. |
