View original (French)

Column Titles

sympatiqueCCM Posted messages 408 Registration date   Status Membre Last intervention   -  
Raymond PENTIER Posted messages 58546 Registration date   Status Contributeur 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 réponses

Réponse 1 / 8
eriiic Posted messages 24581 Registration date   Status Contributeur 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
Réponse 2 / 8
ccm81 Posted messages 11033 Status Membre 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
Réponse 3 / 8
sympatiqueCCM Posted messages 408 Registration date   Status Membre Last intervention   14
 

Thank you very much ccm81.

I have Office 365 and the only tab I have is "Table Creation."
0
Réponse 4 / 8
ccm81 Posted messages 11033 Status Membre 2 434
 

Okay, I misunderstood, see this

If you are using a recent version of Excel (2007 or later), uncheck "Headings" > "Show" from the "Page Layout" tab:

https://www.excel-pratique.com/fr/astuces/masquer_les_entetes

Regards
0
Réponse 5 / 8
Raymond PENTIER Posted messages 58546 Registration date   Status Contributeur Last intervention   17 474
 

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
Réponse 6 / 8
cousinhub29 Posted messages 1110 Registration date   Status Membre 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
Réponse 7 / 8
sympatiqueCCM Posted messages 408 Registration date   Status Membre 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
Réponse 8 / 8
Raymond PENTIER Posted messages 58546 Registration date   Status Contributeur Last intervention   17 474
 

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