Ask Your Question
3

How can I change certain column titles in Excel Power Query?

asked 2021-06-15 11:00:00 +0000

plato gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
2

answered 2021-10-10 16:00:00 +0000

huitzilopochtli gravatar image

You can change certain column titles in Excel Power Query by following these steps:

  1. Open the Power Query Editor by clicking on the "Edit Queries" button in the Home tab of the Excel ribbon.

  2. Select the table or query that you want to modify by clicking on it in the left-hand pane.

  3. Find the column that you want to rename in the list of column names.

  4. Right-click on the column name and select "Rename" from the context menu.

  5. Type in the new name that you want for the column and press Enter.

  6. Repeat this process for any other column titles that you want to change.

  7. When you have finished making all of your changes, click the "Close and Load" button in the Home tab to apply the changes and return to your Excel workbook.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer


Question Tools

Stats

Asked: 2021-06-15 11:00:00 +0000

Seen: 11 times

Last updated: Oct 10 '21