How to Rename Columns in Google Sheets (Headers, Named Ranges)

If you've ever tried to click on the grey letter at the top of a column and type a new name over it, you'll know it doesn't work. Those letters, A, B, C and onwards, are the sheet's coordinates, and Google's help doesn't describe any way to change them.

What you can do is give each column a clear name in three other ways: a header row, a named range, or a table with column headers. Each one solves a slightly different problem, so I'll explain when to use which.

Naming Google Sheets columns with a header row

This is what most people mean by renaming a column, and it's the simplest:

1. Click the cell in row 1 at the top of the column.
2. Type the name you want, such as Customer, Order date or Status.
3. Press Enter and repeat for the other columns.
4. Make row 1 bold so it stands out from the data.

Then freeze it so the names stay visible as you scroll. Google's steps: select the row, click View, then Freeze, and choose how many rows to freeze. To undo it, go back to View, Freeze and pick No rows.

A frozen header row also helps when sorting. Google's sort help suggests freezing the first row if your sheet has a header, so it doesn't get sorted in with the data.

Giving a Google Sheets column a name for formulas

A header row is for people. A named range is for formulas. It lets you write a formula using a word instead of a cell range, which makes it far easier to read later.

1. Select the cells in the column, for example A2 to A10.
2. Click Data, then Named ranges. A panel opens on the right.
3. Type the name, such as orders or hours_logged.
4. Click Done.

Google's help shows how this tidies up formulas: instead of a SUM over cell references, you write SUM with the range names. My walkthrough of adding up a column in Google Sheets shows the cell-reference version, and swapping in a named range works the same way.

Rules for naming a range in Google Sheets

Google is strict about range names. According to its help:

Rule	Example
Letters, numbers and underscores only	hours_logged works, hours logged doesn't
Can't start with a number	q2_orders works, 2q_orders doesn't
Can't be true or false	Pick a descriptive word instead
No spaces or punctuation	Use underscores between words
Between 1 and 250 characters	Short names are easier to type
Can't look like a cell reference	A1 or R1C1 style names aren't allowed

Renaming or removing a named range

To change a name later, go to Data, then Named ranges, click Edit next to it, make your change and click Done. To remove one, click Delete range, then Remove.

Be careful with that second option. Google warns that deleting a named range breaks any formulas that reference it. If you're tidying up an old sheet, search your formulas for the name before you delete it.

Column headers in Google Sheets tables

Google Sheets can also turn a block of data into a table, which gives every column a header you can use in formulas. Google's steps:

1. Select the range of cells.
2. Click Format, then Convert to table.
3. Choose a column type for each column, such as Text, Date, Dropdown or Checkbox.

Google says the table gets a name and each column gets a header, and you can reference those names in formulas. The references update as you add or remove data. The header is a normal cell at the top of the column, so you change the column's name by editing that text. Google's tables article doesn't spell that step out, so if your version behaves differently, menus vary.

To rename the whole table, Google says to use Rename table in the table's menu. Table names can't start with a number, can't go over 255 characters, and can't contain special characters other than underscores.

The Checkbox column type is handy for task lists, and my guide on checkboxes in Google Sheets covers the other ways to add them.

Choosing good column names in Google Sheets

Whatever method you use, the names themselves matter. A column called Date tells you very little in a sheet with three different dates in it. Order date, Ship date and Delivered on are clearer. Short, specific names that describe what's in the cells save everyone questions later, including you in six months.

Keep the same names across sheets that do similar jobs. If your stock list calls it SKU, don't call it Product code in the order sheet, or lookups and copy-pasting between the two get confusing fast.

Which way to name Google Sheets columns

Method	Best when
Header row	You want people to understand the sheet at a glance
Named range	You want formulas that read like words
Table	You want typed columns and headers that formulas follow automatically

For most small business sheets, I'd do the first one every time and add the others only when the sheet starts doing real work, like a running stock list or a content tracker with totals.

If renaming columns in Google Sheets isn't working

• Typing over the letter does nothing: column letters can't be renamed. Type in row 1 instead.
• Named range rejected: check for spaces, punctuation or a number at the start.
• Formula suddenly shows an error: a named range it used may have been deleted.
• Header row sorted into your data: freeze row 1 before sorting.

Frequently asked questions

Can you rename column letters in Google Sheets?

No. Google's help doesn't describe a way to change the A, B, C column letters. Type a name in the first row instead, and freeze that row.

How do I give a column a name I can use in formulas?

Select the cells, click Data, then Named ranges, type a name and click Done.

What are the rules for named ranges?

Google says letters, numbers and underscores only, no spaces or punctuation, no number at the start, not true or false, and 1 to 250 characters.

How do I keep column names visible when I scroll?

Select row 1, click View, then Freeze, and choose how many rows to freeze.

What happens if I delete a named range?

Google warns that any formulas that reference it will break.