How do I rename the references, A,B,C with any text/alphanumeric

[Guest]

Sir, I want to rename the references i.e. A,B,C, and so on (Columns) with any
text or alphanumerics, in Excel 2000 worksheets, plz suggest me. My Mail ID
is "(e-mail address removed)" - Rgds, Md.Siddique.

 

[Guest]

you can assign each column a Named Range. You can then use these Names in
your formulae.

See:

http://www.contextures.com/xlNames01.html

and

http://www.cpearson.com/excel/named.htm