name various cells
 

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

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?

name various cells
 

Thanks for your help in this one.

I did follow the step by step instructions CLARITY on the instructions you
gave is Superb.

It did DEFINITE change in the Name Box but it did not change in the Cell my
still same OLD Name "Allocation" is still showing.

FOR EXAMPLE: I want to REname certain range of cells D8:D12 with a NEW named
called Serving.

"Mike Rogers" wrote:

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?

name various cells
 

A cell (range) can have more then one name.

The displayed name will be the one higher in alphabetical order, even though
either (any) assigned name will work.

Go to <Insert <Name <Define,
And delete the ones you no longer want.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Hope" wrote in message
...
Thanks for your help in this one.

I did follow the step by step instructions CLARITY on the instructions you
gave is Superb.

It did DEFINITE change in the Name Box but it did not change in the Cell my
still same OLD Name "Allocation" is still showing.

FOR EXAMPLE: I want to REname certain range of cells D8:D12 with a NEW named
called Serving.

"Mike Rogers" wrote:

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?

name various cells
 

Hope

To REname a range you must delete the old name, before or after it matters
not but it must be deleted. Be careful deleting a named range in an existing
worksheet. Make sure that named range is NOT used in any other formulas
because once you delete that name the formulas may not work as designed.
REread my first post it explains how to delete a named range.

Mike Rogers

"Hope" wrote:

Thanks for your help in this one.

I did follow the step by step instructions CLARITY on the instructions you
gave is Superb.

It did DEFINITE change in the Name Box but it did not change in the Cell my
still same OLD Name "Allocation" is still showing.

FOR EXAMPLE: I want to REname certain range of cells D8:D12 with a NEW named
called Serving.

"Mike Rogers" wrote:

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?