naming cells
enter num1 in an adjacent column, say your data is in A1:A80, place num1 in
B1. double-click the fill handle so you have num1 thru num80. Select A1:B80,
use Insert/Name/Create and choose "Right Column". When that's done, clear
column B and you're done.
Bob Umlas
Excel MVP
"Dave" wrote in message
...
i have the numbers 1 to 80 in a column of cells. i want to name these
cells
num1, num2 ..... num80. is there an easier way to do this rather than
clicking on each cell and naming it in the name box? i notice that the
cop/paste function doesn't work for the name box. tia
Dave
|