Rename a Column from "A" to "DepartmentName"

[sjay1234]

I need to change my column names so that they are changed from "A", "B", "C" etc to "DepartmentName", "Email", "Phone"..

i have seen a youtube video but when i follow this, it does NOT work in Excel 2019.

Can anyone help as i need to do this and "Protect" the column names so that they cannot be changed.

thanks in advance!

Regards,
Samantha Kidd

 

[Fluff]

What do you mean by change your column names?

 

[sjay1234]

What do you mean by change your column names?

I mean to actually change the column names so at the moment, the name that i have is "A" or "B" and then on the next line, i have a heading like "DepartmentName". I want the "DepartmentName" to be that header.

 

[Tarver]

You can't change the column and row references. Columns are always letters, rows are always numbers.

However, you can create a table, and the name of the columns in the table will persist at the top of your screen when you scroll down through your data.

For instance, I've added by field names in Row 1 of my spreadsheet, and my data goes below. You can see my column names (A, B, C, D) up top. I hit Ctrl-T to create a table (and I gave it a meaningful name instead of "Table1".)

Now, when I scroll down the page, my field names at top (in dark blue) scroll up and replace the column names, like so:

Isn't this what you're trying to accomplish?

 

[sjay1234]

the webpage that i saw on youtube is this:

 

[Tarver]

What you've posted above looks to be a query in the query editor. That's not a regular spreadsheet. A query like that will get field names from what I explained above.

EDIT: Yep, since you've showed the video, that's exactly what it is.

What I explained above creates a table for you. What the video above explains is how to bring data in from another spreadsheet and put it into a table, which is the result of doing what I outlined above. Either way, they're both Excel tables. The query editor has the benefit of letting you connect to data sources (maybe not even your own) that change over time, or connect to large data sets and let you pull out only the little bit of data you need. Either way though, you're working with a table.

 

[Fluff]

As this is dealing with Power Query I'll move it to the correct forum.

 

[sjay1234]

You can't change the column and row references. Columns are always letters, rows are always numbers.

However, you can create a table, and the name of the columns in the table will persist at the top of your screen when you scroll down through your data.
View attachment 17855
For instance, I've added by field names in Row 1 of my spreadsheet, and my data goes below. You can see my column names (A, B, C, D) up top. I hit Ctrl-T to create a table (and I gave it a meaningful name instead of "Table1".)

Now, when I scroll down the page, my field names at top (in dark blue) scroll up and replace the column names, like so:
View attachment 17857

Isn't this what you're trying to accomplish?

the reason that i want to do this is to have a listing where i am not allowed to change the column names.
Will i be stopped from doing this if i use the table? i thought not.
thats why i thought it would be best to have a A. B, C heading names as the actual column names that i need?

 

[Fluff]

You cannot change the column headers, they are either A,B,C or 1,2,3, depending on whether you are using A1 or R1C1 notation.

 

[sandy666]

let
    Source = Table.Combine({Table2, Table1}),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true])
in
    #"Promoted Headers"