How to Rename Columns in Microsoft Excel Queries

By Rob Kemmett

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.

Customize Column Labels

Step 1

Open Microsoft Excel.

Step 2

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

Step 3

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

Step 4

Click "Name."

Step 5

Click "Define."

Step 6

Type the name you wish to give the column.

Step 7

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

Rename Column Labels With Numbers

Step 1

Open Microsoft Excel.

Step 2

Click "Tools" to open a drop-down menu.

Step 3

Click "Options." A new window will open.

Step 4

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

Step 5

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.