How to Rename Columns in Microsoft Excel Queries

Microsoft Excel is a spreadsheet application that gives you the ability to make charts and organize written information. Excel provides you with a grid format that contains both rows and columns. Rows run horizontally and are labeled numerically, while columns run vertically and are labeled with alphabetical characters. Excel’s customization options give you the ability to rename the rows and columns to fit your liking, which is a very simple process.

...
Spreadsheets are a great way to organize and present data.

Customize Column Labels

Step

Open Microsoft Excel.

Step

Click on the column you wish to rename to highlight it.

Step

Click “Insert” on the toolbar at the top of the screen to open a drop-down menu.

Step

Click “Name.”

Step

Click “Define.”

Step

Type the name you wish to give the column.

Step

Click “OK” to save the new label. Repeat these steps for each column you wish to rename.

Rename Column Labels With Numbers

Step

Open Microsoft Excel.

Step

Click “Tools” to open a drop-down menu.

Step

Click “Options.” A new window will open.

Step

Click on the “General” tab to display a list of options.

Step

Uncheck the box next to “R1C1 reference” to rename the columns with numbers instead of letters. To return to using alphabetical labels, check the box.