Click 'Insert' on the top toolbar, select 'Name' 'Define'. In the box that
appears enter your chosen name at the top and the required range at the
bottom. Click 'Add' 'OK' and that's that,
Regards,
Alan.
"art" wrote in message
...
Hello:

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.