How to Name or Rename a Column in Google Sheets
Aug 27, 2024
Last updated: August 25, 2026.
Quick answer: Google Sheets will not let you rename the column letters. A, B and C are fixed. What you name instead is the header cell in row 1: click A1, type your name, and press Enter. To make that name usable in formulas, convert the range to a table with Format > Convert to table, or create a named range.
Get our free Excel formulas cheat sheet
Plus new tutorials and template drops. Enter your email and we'll send it over.
On this page
- Can you rename a column in Google Sheets?
- Method 1: type a name in the header cell
- Method 2: convert the range to a table
- Method 3: use a named range
- Method 4: insert a header row into existing data
- Which method should you use?
- Can you change the column letters themselves?
- Can you rename rows too?
- How do you rename a column on mobile?
- Why is it not working?
- Frequently asked questions
Can you rename a column in Google Sheets?
Partly, and the distinction is what most guides skip.
You cannot rename the column letters. The grey A, B, C strip along the top of the sheet is Google's addressing system. There is no Rename option in its right-click menu, and no setting anywhere that turns column A into a column called Date.
What you can name is the header cell, the first cell of the column, which is what everyone means in practice when they talk about naming, labelling or titling a column. You can also give the column a real name that formulas understand, either by converting the range to a table or by creating a named range.
Rule to remember: the letters are addresses and they never change. The header is a label and you write it yourself.
Four methods follow, in the order you will usually want them.
Method 1: type a name in the header cell
The most straightforward way to name a column, especially when setting up a new sheet.
- Select the header cell. Click the cell at the top of the column you want to name, usually in row 1. To name the first column, click cell A1.
- Type the name. If the column holds dates, type Date into A1.
- Press Enter to confirm. The name now sits at the top of that column.
- Repeat for the other columns, B1, C1 and so on.
To rename it later, click the same cell and type over it. There is nothing to undo first.
Two finishing touches worth the ten seconds. Bold the header row so it reads as a header rather than data. And freeze the header row with View > Freeze > 1 row so the names stay on screen as you scroll.
Rule to remember: a header that scrolls out of sight is not doing its job. Freeze row 1.
Method 2: convert the range to a table
This is the closest Google Sheets comes to genuinely naming a column, because the name becomes something formulas can use.
- Click any cell inside your data.
- Go to Format > Convert to table.
- Google Sheets names the table and treats your first row as column names.
- To rename a column, click its header and type. The change flows through to every formula that referenced it.
The payoff is in formulas. Instead of =SUM(C2:C7), you write a table reference such as =SUM(DeptSales[Sales Amount]). Google's documentation notes that spaces in a name become underscores in formulas, so a table called Sales Tracker is written Sales_Tracker[Sales Amount].
Two things make this better than a plain header row. References update automatically as rows are added or removed, so your totals never miss new data. And the formula says what it means, which matters when someone else opens the file in six months.
Google's help centre covers the wider feature in use tables in Google Sheets.
Rule to remember: a table column name is the only column name that formulas actually understand.
Method 3: use a named range
Useful when you want to refer to a block of cells by name in formulas without converting anything to a table. It names the range, not the column header.
- Select the column or range. To name all the data in column A, click the A at the top to select the whole column.
- Open the panel. Go to Data > Named ranges. A panel opens on the right.
- Name the range. Type a descriptive name such as SalesData. Google Sheets fills in the range you selected, and you can adjust it by hand.
- Click Done. You can now write
=SUM(SalesData)anywhere in the file.
Names cannot contain spaces, cannot start with a number, and cannot look like a cell reference. A1 and Q3 are both rejected for that reason. Google's own guidance on named ranges covers the full rules.
Note the limitation. A named range does not change the header at the top of the column, and it does not appear in the grid. It exists only for formulas.
Method 4: insert a header row into existing data
For a sheet where the data already starts in row 1 and there is nowhere to put the names.
- Make space. Right-click the row 1 number and choose Insert 1 row above. A new empty row appears at the top and everything else shifts down.
- Type your header names across the new row: Date in A1, Sales in B1, Product in C1, and so on.
- Widen the columns if the names are cut off, by dragging the divider between two column letters.
- Freeze the row with View > Freeze > 1 row.
One warning specific to this method: inserting a row shifts every row below it down by one. Formulas elsewhere in the file that point at fixed rows may need checking afterwards.
Which method should you use?
| Method | Use it when | Works in formulas? | Visible in the grid? |
|---|---|---|---|
| Header cell in row 1 | Any new sheet, always | No | Yes |
| Convert to table | The data is a real dataset you will write formulas against | Yes | Yes |
| Named range | You reference the same block repeatedly across a file | Yes | No |
| Insert a header row | Existing data with no free row at the top | No | Yes |
For most people the honest recommendation is the first and second together: type headers in row 1, then convert to a table. That gives you a label you can see and a name your formulas can use.
Can you change the column letters themselves?
No. This deserves stating plainly because a lot of guides imply otherwise.
The column letters are how Google Sheets addresses cells. There is no menu item, no setting and no add-on that renames column A to something else. Right-clicking a column letter gives you options to insert, delete, hide, resize and freeze the column. There is no Rename among them.
What people usually want when they ask this is one of three things:
- To see a meaningful label at the top of the column. Use a header in row 1 and freeze it. The letters stay, and your header sits directly beneath them.
- To write formulas that read clearly instead of using letters. Convert the range to a table, or create a named range.
- To hide the letters entirely. Go to View > Show and switch off gridlines to reduce the clutter, or use File > Print and leave row and column headers unticked so they never reach the printed copy.
Rule to remember: nobody can rename column A. Everyone can put a header above the data and freeze it.
Can you rename rows too?
The same rule applies, in mirror image. Row numbers are fixed, and 1, 2, 3 cannot be renamed.
The equivalent move is to use a label column. Put your row names in column A, then freeze that column with View > Freeze > 1 column so the labels stay visible as you scroll sideways. With the header row frozen as well, you get a spreadsheet where both the column names and the row names stay on screen.
If you want to reference rows by name in formulas, a named range works there too, applied to a row instead of a column.
How do you rename a column on mobile?
In the Google Sheets app for Android and iPhone, naming a column is the same operation as on desktop: tap the header cell, type the name, and confirm.
- Open the spreadsheet in the Google Sheets app.
- Tap the header cell, for example A1.
- Tap again, or tap the formula bar, to start editing.
- Type the name and tap the tick to confirm.
To insert a header row on mobile, long-press the row 1 number and choose Insert row above from the menu that appears. Freezing works from the same long-press menu.
The mobile app does not offer the full desktop feature set, so if a table or named range option is missing, do that part in a browser.
Why is it not working?
| Problem | Cause | Fix |
|---|---|---|
| There is no Rename option on the column letter | The feature does not exist | Name the header cell in row 1 instead |
| The header scrolls off the screen | Row 1 is not frozen | View, Freeze, 1 row |
| Your named range is rejected | The name has a space, starts with a number, or looks like a cell reference | Use letters, numbers and underscores, and do not start with a digit |
| The header got sorted into the data | The sort included row 1 | Undo, then use Data, Create a filter, or convert to a table so the header is protected |
| Renaming a table column broke a formula | A formula used the old name as plain text | Update it, or use table references, which follow renames automatically |
| Formulas shifted after inserting a header row | Every row moved down by one | Check formulas that pointed at fixed row numbers |
| The header cell will not accept text | The sheet or range is protected | Ask the file owner for edit access on that range |
| Column letters are still showing on a printout | Row and column headers are ticked in print settings | File, Print, untick row and column headers |
Final thoughts
Naming a column in Google Sheets is really two decisions. The label your readers see goes in row 1, and it should be frozen. The name your formulas use comes from a table or a named range, and it is worth setting up on any sheet you will maintain for more than a week.
The one thing that is not on the table is renaming the letters. Once you know that, the rest of it takes about a minute.
Go to Simple Sheets for more easy-to-follow guides and examples, and have a look at the related articles below.
Subscribe to Simple Sheets on YouTube for the most straightforward Excel video tutorials.
Frequently asked questions
How do you name a column in Google Sheets?
Click the cell at the top of the column, usually A1 for the first column, type the name you want, and press Enter. That header cell is what Google Sheets and everyone reading the file treats as the column name.
Can you rename a column in Google Sheets?
You can rename the header cell at the top of the column, but not the column letter. The A, B, C strip is Google's addressing system and there is no Rename option in its right-click menu. To rename a header, click the cell and type over it.
How do you label or title a column in Google Sheets?
Labelling and titling a column mean the same thing as naming it. Put the text in the first cell of the column, bold it so it reads as a header, and freeze row 1 with View, Freeze, 1 row so it stays visible while you scroll.
How do you name a column so formulas can use the name?
Convert the range to a table with Format, Convert to table, then reference the column by name, as in SUM(DeptSales[Sales Amount]). A named range created under Data, Named ranges also works, though it names the range rather than the visible header.
Can you rename rows in Google Sheets?
Not the row numbers, which are fixed in the same way column letters are. Put your row labels in column A instead and freeze that column with View, Freeze, 1 column so the labels stay on screen as you scroll sideways.
How do you change a column name in the Google Sheets mobile app?
Open the file in the Google Sheets app, tap the header cell, tap again or tap the formula bar to start editing, type the new name, and tap the tick. To add a header row, long-press the row 1 number and choose Insert row above.
How can you make the header row stand out?
Select row 1 and use the toolbar to bold the text, increase the font size, or add a background colour. Freezing the row with View, Freeze, 1 row helps more than any formatting, because it keeps the names beside the data at all times.
Related Articles
How to Create a Training Tracker in Google Sheets
A Simple Guide on Overlay Graphs in Google Sheets
Want to Make Excel Work for You? Try out 5 Amazing Excel Templates & 5 Unique Lessons
We hate SPAM. We will never sell your information, for any reason.
