View original (French)

Column Titles

sympatiqueCCM Posted messages 408 Registration date   Status Member Last intervention   -  
Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   -

Hello,

I created a table with data in Excel.

At the top of each column, there is a letter, and they follow one another in each column A, B, C, D, etc.

How can I replace these letters with text? Text that would represent each column.

For example: First Name, Last Name, Age, and City.

Thank you very much for your help.


8 answers

  1.
    eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     

    Hello everyone,

    I didn't quite understand the same thing.

    You cannot change the letters of the columns.
    You need to write your column titles in row 1, or in the first row of a table.
    eric

    By continually trying, we eventually succeed.
    So the more it fails, the more chances we have that it works. (the Shadoks)
    In addition to saying thank you (yes, it happens!!!), please remember to mark it as resolved. Thank you

    1
  2. ccm81 Posted messages 11033 Status Member 2 434
     

    Hello

    Not a very good idea but

    You put your headers on the first line

    Excel 2003: Tools/Options/Display/ uncheck row and column headers

    Excel >= 2007Access Table Tools > Design in the ribbon. In the Table Styles Options group, check the Header Row box to show or hide table headers.

    Best regards

    0
  3. sympatiqueCCM Posted messages 408 Registration date   Status Member Last intervention   14
     

    Thank you very much ccm81.

    I have Office 365 and the only tab I have is "Table Creation."

    0
  6. Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
     

    Hello.

    Out of the 103 questions you've asked since October 2006, this seems to be the first one concerning Excel. I believe you are discovering this software.

    So know that in all spreadsheets, the rows are referenced as 1, 2, 3... and the columns are referenced either as A, B, C, D... or 1, 2, 3, 4...

    Follow what ccm81 indicated: In row 1, enter your field names (which are not column names) and in column A, you can enter your record names (which are not row numbers).

    0
  7. cousinhub29 Posted messages 1113 Registration date   Status Member Last intervention   383
     

    Hello,

    This phenomenon can be observed when you create a table (Insert/Table), or when you convert your range into a Structured Table.

    If you haven't frozen the panes, you will see the titles (headers) instead of the column titles when you scroll down your Table.

    Have a good day

    0
  8. sympatiqueCCM Posted messages 408 Registration date   Status Member Last intervention   14
     

    Thank you very much, locking the shutters works well.

    Here is what I get.

    But I would have liked to enter First name, Last name, Age instead of A, B, C, etc...

    0
  9. Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
     

    Why? It's completely unnecessary!

    It's like wanting to remove mile markers on the roads of France, or replacing 36°, 37°, 38° ... on thermometers with "little fever," "somewhat feverish," "very feverish"!

    Moreover, ccm81 and cousinhub29 each suggested an alternative...

    Retirement is great! Especially in the Antilles...
    Raymond (INSA, AFPA)

    0