Change the column label e g change column A to column Name

Question

Can anyone tell me how to change the column label    For example  I want to change Column  A  to Column  Name  in Excel

User · Answer

I would like to present another answer to this as the currently accepted answer doesn't work for me (I use LibreOffice). This solution should work in Excel, LibreOffice and OpenOffice:

First, insert a new row at the beginning of the sheet. Within that row, define the names you need:

Then, in the menu bar, go to View -> Freeze Cells -> Freeze First Row. It'll look like this now:

Now whenever you scroll down in the document, the first row will be "pinned" to the top:

User · Answer

What version of Excel   In general  you cannot change the column letters  They are part of the Excel system   You can use a row in the sheet to enter headers for a table that you are using  The table headers can be descriptive column names   In Excel 2007 and later  you can convert a range of data into an Excel Table  Insert Ribbon   Table   An Excel Table can use structured table references instead of cell addresses  so the labels in the first row of the table now serve as a name reference for the data in the column    If you have an Excel Table in your sheet  Excel 2007 and later  and scroll down  the column letters will be replaced with the column headers for the table column     If this does not answer your question  please consider editing your question to include the detail you want to learn about

User · Answer

If you intend to change A  B  C     you see high above the columns  you can not  You can hide A  B  C     Button Office top left  Excel Options bottom  Advanced left  Right looking  Display options fot this worksheet  Select the worksheet eg  Sheet3  Uncheck  Show column and row headers Ok

[excel] Change the column label? e.g.: change column "A" to column "Name"

Examples related to excel