How to Rename Columns in Google Sheets on PC or Mac

This article will show you different ways to change column names in Google Sheets on desktop. You can edit the name used to refer to the column in the formula, or change the name of the column header.

Change the name of a range of cells (Named Range)

How to Rename Columns in Google Sheets on PC or Mac Picture 1How to Rename Columns in Google Sheets on PC or Mac Picture 1

Go to https://sheets.google.com in a web browser. If you're not signed in to your Google account, follow the onscreen instructions to sign in now.

Use this method to create or edit a name that represents a range (e.g. 'Budget' replaces 'D1:E10',) that you can use to reference it in formulas.

To change the name that appears in the header at the top of a column, refer to this method.

How to Rename Columns in Google Sheets on PC or Mac Picture 2How to Rename Columns in Google Sheets on PC or Mac Picture 2

Click the file you want to edit.

How to Rename Columns in Google Sheets on PC or Mac Picture 3How to Rename Columns in Google Sheets on PC or Mac Picture 3

Click a column letter. This is the letter on the column you want to name. The entire column will be selected.

How to Rename Columns in Google Sheets on PC or Mac Picture 4How to Rename Columns in Google Sheets on PC or Mac Picture 4

Click the Data menu . This section is at the top of Sheets.

How to Rename Columns in Google Sheets on PC or Mac Picture 5How to Rename Columns in Google Sheets on PC or Mac Picture 5

Click Named ranges . The 'Named ranges' panel will display on the right side of the sheet.

How to Rename Columns in Google Sheets on PC or Mac Picture 6How to Rename Columns in Google Sheets on PC or Mac Picture 6

Enter a name for the range of cells. The range name cannot start with a number or the words 'true' or 'false'. A name can be up to 250 characters long, including letters, numbers, and underscores.

If the field is empty, simply enter a name for the range.

If the range already has a name and you want to change it, tap the pencil icon, then type a new name.

How to Rename Columns in Google Sheets on PC or Mac Picture 7How to Rename Columns in Google Sheets on PC or Mac Picture 7

Press Done . The column/range name is currently being updated. If there are formulas that refer to old names, you need to update them.

Change column headers

How to Rename Columns in Google Sheets on PC or Mac Picture 8How to Rename Columns in Google Sheets on PC or Mac Picture 8

Go to https://sheets.google.com in a web browser. If you're not signed in to your Google account, follow the onscreen instructions to sign in now.

Column headings are the text that appear at the top of each column.

If you haven't created column headers yet, consult.

How to Rename Columns in Google Sheets on PC or Mac Picture 9How to Rename Columns in Google Sheets on PC or Mac Picture 9

Tap the file you want to edit.

How to Rename Columns in Google Sheets on PC or Mac Picture 10How to Rename Columns in Google Sheets on PC or Mac Picture 10

Double-click the column header you want to change.

How to Rename Columns in Google Sheets on PC or Mac Picture 11How to Rename Columns in Google Sheets on PC or Mac Picture 11

Use ← Backspace or Delete to delete the current name.

How to Rename Columns in Google Sheets on PC or Mac Picture 12How to Rename Columns in Google Sheets on PC or Mac Picture 12

Enter a new name.

How to Rename Columns in Google Sheets on PC or Mac Picture 13How to Rename Columns in Google Sheets on PC or Mac Picture 13

Press ↵ Enter or ⏎ Return. Column names have now been updated.

4 ★ | 1 Vote