Change cell refrence names for whole column/row
 

I have following spreadsheet

A B C
1
2 Project Type Sub-type
3
4

Can i somehow rename whole column name from A to proj, from B to type from C
to stype to be able to reference these cells bb new defined names?

For example i could then refrence to cell A3 as Proj3 or C4 as stype4?

Almost
..
First, name the columns: select the headers plus all of the column (at
least, as far as you need). InsertNameCreate, check Top row
Now apply Excel's other addressing system: ToolsOptionGeneral, check R1C1
Reference style

Now you can refer to Project R4 (note the space before R4: the space is the
Intersection operator)

If you don't like to change to the other reference style, the reference
would be Project $2:$2

But it would be even better to define names for the rows as well, and use
both names and the intersection operator

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Mikus" wrote in message
...
I have following spreadsheet

A B C
1
2 Project Type Sub-type
3
4

Can i somehow rename whole column name from A to proj, from B to type from
C
to stype to be able to reference these cells bb new defined names?

For example i could then refrence to cell A3 as Proj3 or C4 as stype4?