Defining lists

  • Thread starter Thread starter GKW in GA
  • Start date Start date
G

GKW in GA

How do I redefine a list in Excel. Lets say I've defined List1 to be rows
A1:A50 and now I want List1 to be A1:A100. Also, how do I remove the name of
a list, i.e., I don't want to have a List1 anymore or I want A1:A50 to be
called List111
 
Try: Insert->Name

This will allow you to define new ranges, delete defined ranges, or
re-define ranges. Hope this helps!
 
Take a look at the name manager addin as it is exceptionally good fo
rmanaging named ranges...

http://www.oaltd.co.uk/MVP/

As for creating a simple named range you can just type it directly into the
Name Box in XL (directly to the left of the formula editor on the formula
bar). Make sure to hit enter when you finish entering the name...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging multiple columns into one column (dynamically) 1
VLOOKUP question 2
merging multple columns into one column (dynamically) 2
How to I filter one list based on another list? 4
Combine Lists 1
Referring to Ranges in Change-Event Macro? 4
Outlook Validation formula help 0
Name a list in Excel 2003? 8

Back
Top