Forum home » Delegate support and help forum » Microsoft Excel Training and help » course excel training vba london - V look up
|
|
|
The UK's most regular 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. |
course excel training vba london - V look up
Resolved · Low Priority · Version Standard
Reply Wed 9 Jan 2008, 11:24Delegate Matthew said...
Matthew has attended:
Excel Intermediate course
V look up
How do I assign names to data in a huge data list?
For upcoming training course dates see: Pricing & availability
RE: V look up
Hi Matthew
Thank you for your question, and apologies for the delay in reply.
You can assign names to cell ranges by doing the following:
1. Select the cell range you wish to name
2. Click in the Name box (near the top of your screen, under the box where you choose the font type).
3. Enter a name for the range, without using spaces as part of the range name
4. Press Enter to assign the name to the cell range.
To edit the cell range that the name refers to:
1. Go to Insert/Name/Define
2. Select the name of the range from the large box.
3. Use the Refers to: box at the bottom of the dialogue box to reselect the cell range.
4. Click OK.
You can also add and delete named ranges from within the same dialogue box.
I hope this helps.
Amanda
|