How to rename a column title in excel?

If you mean to change the "A", "B", "C" column headers, you
can't.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"atta" wrote in message
...
How to rename a column title in excel?

Tools Options GeneralTab check the box marked "R1C1 reference
style".........that will change columns A, B, C, etc to columns 1, 2, 3,
etc..... other than that, I know of no other way to change them to be
"words" or anything else.

Vaya con Dios,
Chuck, CABGx3


"atta" wrote in message
...
How to rename a column title in excel?

You can put titles that you want to see on row 1
and column A, then hide the column and row headers,
file, page setup, sheet, hide row and column headers
then you can fake the row numbers by placing =ROW()-1 into cell B2,
which might be fine for a report, but it would be a big pain to
maintain as an Excel file.
--
David McRitchie, Microsoft MVP - Excel

"Chip Pearson" wrote in message ...
If you mean to change the "A", "B", "C" column headers, you
can't.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"atta" wrote in message
...
How to rename a column title in excel?

What is advantage of doing so? Raw and columns are just reference
number for addressing, that is all. No other function is requested.

If you quoted part of the post you are posting a comment/answer to, your
post would be less confusing?

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Khoshravan" wrote in message
oups.com...
What is advantage of doing so? Raw and columns are just reference
number for addressing, that is all. No other function is requested.