Download Article
Easy ways to title, label, or name columns in Microsoft Excel
Download Article
You can create a column title in Microsoft Excel by inserting a new row at the top. Once it's created, you'll just need to double-click the cell and type in your label. Here's how to name a column in Excel.
Quick Steps
- Click a row number to highlight the entire row.
- Right-click the first cell and click Insert .
- Double-click the new cell and enter a name.
- Press Tab to enter a name for the next cell.
Steps
-
Open a workbook in Microsoft Excel . You can use an existing project or create a new spreadsheet . Make sure you're on the correct worksheet.
- Microsoft Excel is available on Windows and Mac . You can also use the online web version at https://www.office.com/ .
-
Insert a new row for the names. If you want it at the very top of the page, click 1 on the left side of the spreadsheet to highlight the entire first row. Right-click the first cell, and click Insert . This will place a blank row above your data. [1] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
- If you want the new row in another location, select the row number of the location. Right-click the first cell, and click Insert .
- If you already have a row for the names, skip to the next step.
Advertisement -
Double-click the first cell and enter a name. This will be the title of the first column.
-
Double-click the next cell and enter a name. You can also press Tab to skip to the next cell in the column. Repeat this for any remaining title cells.
- If you only have one column to name, skip this step.
- The headers at the top (letters A-Z) will not change since these are Excel’s way of keeping track of information within your document. However, when you type in a name for column A1, that will become the name for the rest of the “A” column.
- If you want to see the titles
as you scroll down, do the following:
- Click View at the top.
- Click Freeze Panes .
- Click Freeze Top Row .
Advertisement
-
Open Microsoft Excel. You can use an existing project or create a new spreadsheet.
- Use this method if you want to turn the column names (letters A-Z) into numbers instead.
-
Select File and click Options . This will be at the bottom of the left panel.
- On Mac, you'll need to click Excel and then Preferences .
-
Click Formulas . This is in the left panel.
- On Mac, click General .
-
Check the box for "R1C1 reference style". This is underneath the Working with formulas header.
-
Click OK . This is at the bottom-right corner of the window.
- The header columns will change from letters to numbers.
Advertisement
-
Open the Power Query Editor. Power Query is an add-on you can use in Excel. This allows you to import data through other sources. [2] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
-
Open a query. You can do this by using a previously loaded query in the Editor, or you can click a cell in the data, select Query , then click Edit .
-
Select the column you want to name. It will be highlighted.
-
Double-click the column header. This will allow you to rename it.
- You can also select Transform , then Rename at the top.
-
Enter the new column name. This will name the header.
- Keep in mind that renaming a column header won't rename the original data source header. If the original data source header changes, it can cause query errors.
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Video
Tips
Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Thanks for submitting a tip for review!
References
About This Article
Article Summary
X
1. Open your Excel document.
2. Double-click on the first box under the column you want to rename.
3. Type in the name you want and press enter.
Did this summary help you?
Thanks to all authors for creating a page that has been read 68,917 times.
Advertisement
