Change column name??????

B

BH79

:rolleyes: *Can somebody help my out?????? I would like to know how to
change the column name (A, B, C etc) into a different name...*
 
Y

YS10

Good question BH 79 , I also would really like to know this and can't
find anything about it :confused:. But I have seen docs in which the
columns have names instead of the usual a,b,c-labels... Hope someone
knows the answer...
 
P

Paul

BH79 > said:
:rolleyes: *Can somebody help my out?????? I would like to know how to
change the column name (A, B, C etc) into a different name...*
Click to expand...

You cannot change the column letters themselves (except to numbers in the
R1C1 style of cell references). What you can do is to use row 1 for your own
headings, with your data starting in row 2.
 
P

Peo Sjoblom

You can't, you could hide all headers and then create your own but the
references would still have to be there
 
N

Norman Harker

Hi BH79!

No. You can type in a row of names in Row 1 and hide the Row and
Column headers using Tools > Options > View. Not generally recommended
as it confuses with formulas but there are situations where you might
use the approach.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top