How Do You Name Columns in Excel 2013?

Adding a row of headings to the top of your spreadsheet is an effective way to describe the data in your cells.

This is especially important when a printed sheet extends across multiple pages. but you might be asking how do you name columns in Excel if you have already entered all of your data and didn’t leave a blank row at the top.

How to Create Excel Column Names

  1. Open your spreadsheet.
  2. Select the top row number.
  3. Right-click the selected row and choose Insert.
  4. Enter column names in the blank row.

Our guide continues below with additional information to answer the question of how do you name columns in Excel, including pictures of these steps.

Putting descriptions for columns at the top of your spreadsheet is a great way to label your data and make it easier to understand.

This is such a common practice that Excel actually gives a name to it, which is the “title row.” You can even choose to freeze that title row if you would like it to remain visible when you scroll down your spreadsheet.

Our tutorial below will show you how to insert a new row at the top of your spreadsheet so that you can use it as a title row.

We will also discuss how to turn a selection with title rows into a table in Excel so that you can perform other actions on your data, such as filtering and sorting.

Check out our Microsoft Excel add column tutorial and learn about easy ways to get sums of cell data.

How to Add a Title Row to a Spreadsheet in Excel 2013 (guide with Pictures)

The steps in this article were performed in Microsoft Excel 2013. These steps will work in other versions of Excel as well. We will also discuss turning a selection of cells into a table in Excel in the section below, which may be closer to the result you are trying to achieve, if adding the title row isn’t the desired result.

Step 1: Open your spreadsheet in Excel 2013.

Step 2: Click the top row number at the left side of the spreadsheet.

If you haven’t hidden any rows, then this should be row 1.

name columns in excel

Step 3: Right-click the selected row number, then choose the Insert option.

You can also insert a new row when a row is selected by pressing Ctrl + Shift + + on your keyboard.

excel 2013 how to name columns

Step 4: Add column names into the blank cells in this new row.

how do you name columns in Excel

Our article continues below with another answer to the question of “how do you name columns in Excel” which involves creating a table from your existing data.

How to Turn a Selection Into a Table in Excel 2013

Now that you’ve added your column names, you can go one step further by turning a selection into a table with the steps below.

For more information, you can read our complete guide to creating tables in Excel.

Step 1: Select the cells that you want to include in the table.

select data range with column names

Step 2: Click the Insert tab at the top of the window.

excel column names

Step 3: Select the Table button in the Tables section of the ribbon.

create a table in excel

Step 4: Confirm that the My table has headers option is checked, then click the OK button.

create table with column names in excel

If you scroll down in your table you will see that the table column names replace the column letters while the table is still visible.

how to name columns in excel

Hopefully this has helped you to answer the question of how do you name columns in Excel?

Now that you’ve set up your table in the manner that you want, one of the next hurdles will be getting it to print properly. Check out our Excel printing guide for some tips on making your spreadsheet a little easier to manage when it’s printed on paper.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time. Read our Privacy Policy