Guide2026-11-096 min read

How to Rename a Column in Google Sheets (What Actually Works)

You can't rename the column letters (A, B, C...) in Google Sheets; they are fixed labels for the grid. To give a column a name, type it into row 1 as a header and freeze that row with View > Freeze > 1 row. If you also want to use the name in formulas, either name the range with Data > Named ranges, or turn the data into a table with Format > Convert to table, which gives every column a real name you can reference.

Which option fits depends on what you want the name for. The sections below cover each one, with exact menu paths for Google Sheets in a desktop browser.

Why you can't rename the column letters

The grey letters across the top of the sheet are part of the grid's coordinate system, like the row numbers on the left. Every formula reference such as A1 or B2:B50 depends on them, so Sheets doesn't let you change them, hide them or replace them with words. Excel works the same way.

What people usually mean by "renaming a column" is one of three things:

  • A label people can read: a header row.
  • A name formulas can use: a named range or a table column.
  • A different heading in a report or result: a QUERY label or a custom header above a formula.

Option 1: Add a header row and freeze it

This is what most spreadsheets do, and for many uses it is all you need.

  1. If row 1 already holds data, right-click the row number 1 and choose Insert 1 row above.
  2. Type a name for each column in row 1, for example Date, Customer, Amount.
  3. Go to View > Freeze > 1 row. Row 1 now stays visible when you scroll down.
  4. Optionally make the headers stand out: select row 1 and apply bold, a fill colour, or Format > Text wrapping > Wrap for long names.

To rename the column later, click the header cell and type the new name. Nothing else changes, because formulas point at cell addresses, not at the header text.

Sheets recognises a header row in several places. When you sort with Data > Sort range > Advanced range sorting options, tick Data has header row so the headers aren't sorted into the data. Filters (Data > Create a filter) put their buttons in the header row, and charts and pivot tables use the header text as series and field names.

Option 2: Name the column with a named range

A named range lets you write =SUM(Amount) instead of =SUM(C2:C500). It doesn't change what you see in the grid, but it makes formulas readable.

  1. Select the cells, for example C2:C500. To name the whole column, click the column letter.
  2. Go to Data > Named ranges. A panel opens on the right.
  3. Type the name and click Done.

You can also open the same panel from the range box at the top left of the sheet: click its drop-down arrow and choose Manage named ranges.

Google's rules for range names:

  • Letters, numbers and underscores only; no spaces or punctuation.
  • Can't start with a number, and can't be true or false.
  • 1 to 250 characters.
  • Can't look like a cell reference, such as A1 or R1C1.

So Amount and order_total are fine; Order Total and Q1 style names that resemble cell addresses are not.

To rename a named range, open Data > Named ranges, click the range, edit its name and click Done. After renaming, check a formula or two that used it. Deleting a named range breaks any formula that refers to it.

Option 3: Convert the data to a table

Tables are the closest Google Sheets gets to real column names. Each column in a table has a name, a type and its own menu, and you can refer to columns by name in formulas.

  1. Select the data range, including the header row.
  2. Go to Format > Convert to table.
  3. Sheets turns the first row into column names and applies table formatting. Use each column's menu to set a column type (text, number, date, dropdown and so on) with Edit column type.
  4. To rename a column, click its header cell in the table and type the new name.
  5. To rename the table itself, open the table menu (the arrow next to the table name above the table) and choose Rename table.

Once it's a table, formulas can use structured references:

=SUM(Sales[Amount])

Sales is the table name and Amount is the column. If a table name contains spaces, Sheets writes it with underscores in formulas, so "Table 1" becomes Table_1. Other forms include Sales[#HEADERS] for the header row only and Sales[[#ALL],[Amount]] for the column including its header.

Tables work best on clean data: one header row, no blank rows and no subtotal rows in the middle. If your range has those, tidy it before converting.

Option 4: Rename a column only in a result

Sometimes you want a different heading in a summary without touching the source data.

QUERY function: the label clause renames output columns.

=QUERY(A1:C, "select A, sum(C) group by A label sum(C) 'Total amount'", 1)

The final 1 tells QUERY that the range has one header row. Without the label clause, QUERY builds the heading from the function name and the original header.

Array literal: put your own header above a filtered or computed column.

={"Customer"; FILTER(B2:B, C2:C > 100)}

Which option should you use?

You want toUse
See what each column holdsHeader row in row 1, frozen
Write readable formulasNamed range, or a table column reference
Typed columns, filters and named columns in one stepFormat > Convert to table
A different heading in a summary onlyQUERY label or an array literal

Tips for naming columns

  • Keep headers short and unique. Two columns called "Date" make filters, pivot tables and table references confusing.
  • Avoid line breaks and trailing spaces in headers; they cause mismatches when the sheet is exported and loaded into another tool.
  • If the sheet feeds a database, a script or a data tool, use names that work there too: order_date imports cleanly, "Order Date (UTC)" usually needs renaming later. Our naming conventions guide explains the common styles.

If you download the sheet as CSV or Excel and need to rename the columns in code, see rename columns in pandas or rename a column in SQL. To rename the spreadsheet file itself, see how to rename a file.

Frequently Asked Questions

Can you rename column letters in Google Sheets?

No. The column letters A, B, C and so on are fixed grid coordinates that every cell reference depends on, so Google Sheets doesn't allow renaming or hiding them. Use a header row in row 1 to label columns instead.

How do I name a column in Google Sheets?

Type the name in row 1 of that column and freeze the row with View > Freeze > 1 row. To use the name in formulas, select the column and create a named range with Data > Named ranges, or convert the data to a table with Format > Convert to table.

How do I make the first row a header in Google Sheets?

Type your column names in row 1, then choose View > Freeze > 1 row so it stays visible while you scroll. When sorting, use Data > Sort range > Advanced range sorting options and tick Data has header row so the header isn't sorted with the data.

How do I rename a column in a Google Sheets table?

Click the column's header cell inside the table and type the new name. The table's column menu is where you change the column type. To rename the whole table, open the table menu next to the table name and choose Rename table.

Why can't I use spaces in a named range?

Google Sheets range names may contain only letters, numbers and underscores, must not start with a number and must not look like a cell reference. Use underscores instead of spaces, for example order_total.

Does renaming a header break my formulas?

Not if the formulas use cell references such as C2:C500, because they don't depend on the header text. Formulas that look up a column by its header text, such as MATCH on the header row or a QUERY that relies on header names, may need updating.

Ready to organize your files?

Try AI renaming right away. No sign-up needed until you download.

Try It Free