Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
naming cells
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
naming cells
You could put it in a macro
For a = 1 To 80 ActiveWorkbook.Names.Add Name:="num" & a, RefersToR1C1:="=Sheet1!R" & a & "C1" Next a "Dave" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Naming cells... | Excel Worksheet Functions | |||
how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions |