Hi Ben

I read your question slightly differently to Don, who gave you a method of
creating a named range.
I interpreted you request as wanting to enter a label, but have it spread
across many columns.
If that is correct, then select the cells you wantRight
clickFormatCellsAlignmentHorizontalCenter across Selection.

--
Regards
Roger Govier

"ben" wrote in message
...
how do you name a column to extend over several columns in excel?

__________ Information from ESET Smart Security, version of virus
signature database 4743 (20100104) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4743 (20100104) __________

The message was checked by ESET Smart Security.

http://www.eset.com