Suppose your data is in Column A, select all of the data, then go to Insert > Name > Define. At the bottom of the window in the "Refers To" box, it should have the references, i.e. $A$1:$A25. At the top of the dialog box, type in a name (no spaces), click "Add." Then close the dialog box.
old, slow, and confused
but at least I'm inconsistent!