I'm not really sure what sort of further facilitation you're looking for,
since you know about the name box (from your subject line).

Perhaps this? You can easily create it with one fell swoop if you name the
ranges using the top col labels via Insert Name Create. Eg with col
labels in A1:E1, you could select the entire range, eg A1:E100, then click
Insert Name Create, ensure only "Top row" is checked, then click OK.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"art" wrote:
How can I name a range like for E.G. A1:A200 and also C1:C200 and so on
without selecting actually the cells. I want to be able to do it by typing
the range is there a way to do it? Otherwise it would take me very long to
select all the cells I need. Please help.