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

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

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

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

Examples related to excel