how to name many columns
 

how do you name a column to extend over several columns in excel?

how to name many columns
 

just select the columns and put a name in the NAME box next to the formula
box

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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

how to name many columns
 

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