Change cell refrence names for whole column/row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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). Insert>Name>Create, check Top row
Now apply Excel's other addressing system: Tools>Option>General, 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
 
Back
Top