Wednesday, February 22, 2012

How to Rename Columns in Microsoft Excel Queries


Customize Column Labels
1. Open Microsoft Excel.
2. Click on the column you wish to rename to highlight it.
3. Click 'Insert' on the toolbar at the top of the screen to open a drop-down menu.
4. Click 'Name.'
5. Click 'Define.'
6. Type the name you wish to give the column.
7. Click 'OK' to save the new label. Repeat these steps for each column you wish to rename.
Rename Column Labels With Numbers
8. Open Microsoft Excel.
9. Click 'Tools' to open a drop-down menu.
10. Click 'Options.' A new window will open.
11. Click on the 'General' tab to display a list of options.
12. 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.

Blogger news