How to Rename Columns in Google Sheets

Google Sheets can’t rename the column letters (A, B, C). Instead, type a heading such as Date into the top cell of each column and freeze that row; for formulas, add a named range or convert the data to a table.

The columns in your spreadsheet are labeled A, B, C, and you want them to say something useful like Date, Amount, and Category. These steps use Sheets in a web browser, with notes for the app.

Why the Column Letters Can’t Change

The gray letters above the grid are cell addresses, not labels. Every formula in Sheets uses them (B2, C2:C40 and so on), so they stay fixed no matter what the column holds. Right-clicking a column letter gives you options to insert, delete, hide or resize the column, but no rename command, and Google’s help pages describe no way to replace the letters with words.

When people talk about a “column name” in Google Sheets, they almost always mean one of three things:

• A heading: text in the top cell of the column that people read.
• A named range: a name that formulas can use instead of a cell address.
• A table column name: the header of a column inside a Sheets table, which comes with column types and a table menu.

If you actually wanted to rename the tab at the bottom of the screen (Sheet1, Sheet2), that is a different task, covered in renaming, adding or hiding a sheet tab in Google Sheets.

Give a Column a Heading in Row 1

This is the method that works for everyone, and it’s what most people mean by renaming a column. Say you track household spending with dates in column A, dollar amounts in column B and spending categories in column C.

1. Open the spreadsheet at sheets.google.com.
2. Click cell A1. If it already holds data, add an empty row first (see the next section).
3. Type Date and press Enter. To change a heading that’s already there, select the cell and type over it, or double-click it to edit part of the text.
4. Click B1, type Amount, then click C1 and type Category.
5. Optional: select row 1 and make it bold or give it a fill color so it reads as a heading rather than data.

The letters A, B and C still appear above your headings. That’s expected. Your headings are ordinary cell contents, so you can edit, copy, sort and filter them like any other text. For more ways to style and set up the top row, see making a header row in Google Sheets.

Add a Row Above Data That Starts in Row 1

If your numbers begin in row 1, typing a heading there would overwrite them. Right-click the row number 1 on the left edge and choose the option to insert one row above. Your data shifts down one row, and formulas that refer to the moved cells normally update to follow them. The full set of options is in inserting a row in Google Sheets.

Keep the Headings Visible While You Scroll

A heading row helps most when it stays on screen. Google’s freeze rows and columns help page gives this route on a computer:

1. Click anywhere in row 1.
2. Open the View menu and choose Freeze.
3. Select 1 row.

A thick gray line appears under row 1, and the headings stay in place as you scroll down. To undo it, go to View > Freeze > No rows. Freezing a column instead (for example, to keep a name column visible while you scroll right) works the same way, as shown in freezing columns or rows in Google Sheets.

Headings also make sorting safer. When you sort with Data > Sort range, check Data has header row so your heading stays at the top instead of being sorted in with the data. Google’s sort help page also suggests freezing the first row when your sheet has a header row.

Name a Column for Use in Formulas

A heading is for people. A named range is for formulas. Once column B (the amounts) has a name like expenses, you can write =SUM(expenses) instead of =SUM(B2:B200), which is easier to read and harder to get wrong. Google’s steps from its named ranges help page:

1. Select the cells you want to name, such as B2:B200 (leave the heading cell out if you only want the numbers).
2. Click Data > Named ranges. A panel opens on the right.
3. Type a name, such as expenses.
4. To change which cells the name covers, click the spreadsheet icon in the panel and adjust the range.
5. Click Done.

Google sets these rules for range names:

• Only letters, numbers and underscores. No spaces or punctuation, so use monthly_total, not “monthly total”.
• The name can’t start with a number, and it can’t be “true” or “false”.
• It must be 1 to 250 characters long.
• It can’t look like a cell reference, such as A1 or R1C1.

To rename or resize a named range later, open Data > Named ranges and click the edit (pencil) icon next to it. Be careful with deleting one: Google warns that formulas using a deleted name stop working, so update those formulas first. If you plan to look values up by column, named ranges also pair well with lookup formulas such as VLOOKUP in Google Sheets.

Turn the Data Into a Table With Named Columns

Google Sheets tables give a block of data a built-in header row, a column type for each column (such as date, number or dropdown) and a table menu. Google’s tables help page describes the conversion:

1. Type your headings in the top row of the data, then select the whole range, headings included.
2. Click Format > Convert to table.
3. Choose a column type for each column. You can change it later from the column menu next to the header with Edit column type.

The table takes its column names from the header cells you typed. Google’s page doesn’t spell out a separate rename command for a table column, so if you want different wording, look for the header text in the first row of the table and edit it there. The table itself can be renamed from the table menu with Rename table. Table names follow rules similar to named ranges: no TRUE or FALSE, no names that look like cell references, no leading number, no special characters other than underscores and no more than 255 characters.

Rename Headings in a Pivot Table or QUERY Result

Some column headings are created by Sheets rather than typed by you, and those follow their own rules.

Pivot tables. Click the pivot table, then click the Edit button that pops up underneath it, then click the name of a row or column field and type a new name. According to Google’s pivot table page, the pivot table editor then shows the original field name with your new name in parentheses, and the Grand total heading can’t be renamed.

QUERY formulas. A QUERY result writes its own heading row, and typing over it won’t stick because the formula owns those cells. Use the label clause instead. In Google’s query language reference, the clause sets the label for one or more columns, including the output of an aggregation. For example, =QUERY(A1:C200, "select C, sum(B) group by C label sum(B) 'Total spent'", 1) totals the amounts by category and heads the second column Total spent instead of “sum Amount”.

Rename Columns in the Google Sheets App

The phone and tablet app has the same limit: the column letters stay. To add or change a heading, open the spreadsheet, select the top cell of the column, type the heading in the edit bar and confirm it (on most versions, a check mark next to the edit bar). On Android, Google’s help page says you freeze the heading row by touching and holding the row number, then choosing Freeze (and Unfreeze to undo it). On an iPhone or iPad, the app may offer a similar option when you tap a row number; if you don’t see one, freeze the row from a computer and the setting carries over to the app.

Which Method Fits Your Sheet

What you want	Use	Where
Readable labels for people	Heading in row 1	Type in the top cell
Labels that stay on screen	Heading plus frozen row	View > Freeze > 1 row
Formulas that use a word instead of B2:B200	Named range	Data > Named ranges
Column types, dropdowns and a structured block	Table	Format > Convert to table
Friendlier labels on a summary	Pivot table field name or QUERY label	Pivot editor or the formula

Many sheets use two of these at once: headings in a frozen row for anyone reading the sheet, plus a named range on the one or two columns that formulas use most.

A few habits make headings easier to work with. Keep them short and specific (Amount rather than Money spent this month in dollars), give every column a different heading, and avoid merged cells in the heading row, since merged cells can get in the way when you sort or filter. A clear heading row is also what filters rely on, as explained in creating a filter in Google Sheets.

If Something Doesn’t Work

• The heading changes back or won’t edit. The cell is probably filled by a formula (QUERY, ARRAYFORMULA, IMPORTRANGE). Click the cell and check the formula bar; change the heading inside the formula, as with the QUERY label above. A protected range can also block edits; the sheet owner controls that.
• Sheets rejects your range name. Check the rules above. Spaces, hyphens, a leading number or a name like Q1 or AB12 (which looks like a cell address) are the usual causes.
• Formulas show an error after a change. A named range may have been deleted or renamed. Re-create it with the old name or edit the formulas to use the new one.
• The heading row ends up in the middle after sorting. Press Ctrl+Z (Cmd+Z on a Mac) to undo, then sort again with Data has header row checked, or freeze row 1 first.

Column Naming Questions

Does changing a heading break my formulas?

No. Ordinary formulas point at cell addresses like B2:B200, and the letters never change, so editing the words in row 1 has no effect on them. The exception is a table: Google says each table column gets a name from its header, and formulas can refer to cells by those names, so check any formula that uses a table column name after you edit that header.

Can two columns have the same heading?

In a plain sheet, yes, because headings are just text. It’s still a bad idea: sort dialogs, filters and charts list columns by their heading, and two identical entries are easy to mix up. Add a detail, such as Amount (planned) and Amount (actual).

Can I name a whole column, including rows I add later?

Usually, yes. In the Named ranges panel, try an open-ended range such as Sheet1!B2:B, with no end row. Sheets generally treats that as everything from B2 down, so new entries are included without editing the name. If you prefer a fixed range, make it longer than you need, such as B2:B1000.

How do I hide a column instead of renaming it?

Right-click the column letter and choose the hide option. The data stays in the sheet and formulas still use it. The full steps, including unhiding, are in hiding and unhiding a column in Google Sheets.

Start with the heading row and a frozen top row; that alone solves the problem for most sheets. Add a named range or a table only when your formulas or data entry would benefit from it.