How to rename a column title in excel?

C

Chip Pearson

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
 
C

CLR

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
 
D

David McRitchie

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.
 
K

Khoshravan

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

Peo Sjoblom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Re-title multiple MS Project .mpp files at once 0
Replacing a phrase with carriage returns 1
Remove title bar and phase bar by default on swimlane 0
Msg Box Title 5
Rename Sheet from a cell value 3
Rename the a column title 2
List all tables, including document structure 0
Adding a big matrix in Word 2013 5

Top