If the cells are contiguous: type names in column to left or row above
(insert column/row if needs be)
Use Insert|Name|Create
Now delete the row/column of names
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"hmm" wrote in message
...
I know that pressing F2 will put you in the formula bar. However, is there
a
keyboard shortcut for putting you in the name box (I have a large number
of
cells to name). Thanks.