One way:

Choose Insert/Name/Define:

Name in workbook: xyzlabels
Refers to: !$A$1:$A$10


In article ,
"Gilbert De Ceulaer" wrote:

How can I - in one operation - give the same name to the same range in
different worksheets ?
("xyzlabels" refer to the same (label)-range, but as well in sheet "1999",
as in "2000", as in....)