View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Rogers Mike Rogers is offline
external usenet poster
 
Posts: 194
Default name various cells

Hope

Select the range you want to name. Goto the name box, it is located just
above column A and it has a drop down arrow. Click inside the name box and
enter the name you want for the range you have selected. When you are done
you must hit "Enter" to name that range. Or you could goto (after selecting
your range) InsertNamedefine, and enter your range name there and ok out.

It is nice to know both ways because you can quickly find a named range by
clicking the name box drop down, and you can delete a range in the
insertname.....place.

Does this help You?

Mike Rogers

"Hope" wrote:

What is the step by step instructions on naming range of selected cells?