A quick and easy guide to naming ranges and columns
This wikiHow teaches you different ways to change column names in Google Sheets on a computer. You can either edit the name you use to reference the column in formulas, or change the column’s header title to something new.
Steps
Method 1
Method 1 of 2:
Changing the Name of a Range (Named Range)
-
Go to https://sheets.google.com in a web browser. If you’re not already signed in to your Google account, follow the on-screen instructions to sign in now.
- Use this method to create or edit the name that represents a range (e.g. “Budget” in place of “D1:E10”) that you can use to reference it in formulas. [1] X Research source
- To change the name that appears in the header at the top of the column, see this method instead .
-
Click the file you want to edit.Advertisement
-
Click a column letter. This is the letter above the column you want to name. The entire column is now selected.
-
Click the Data menu. It’s at the top of Sheets.
-
Click Named ranges . The “Named ranges” panel now appears on the right side of the sheet.
-
Enter a name for the range. Range names cannot begin with a number or the words “true” or “false.” They can be up to 250 characters, including letters, numbers, and underscores. [2] X Research source
- If the field is blank, simply type a name for the range.
- If the range already has a name and you want to change it, click the pencil icon, then enter a new name.
-
Click Done . The column/range’s name is now updated. If you have formulas that reference the old name, you'll need to update them.Advertisement
Method 2
Method 2 of 2:
Changing a Column Header
-
Go to https://sheets.google.com in a web browser. If you’re not already signed in to your Google account, follow the on-screen instructions to sign in now.
- Column headers are the text that appear at the top of each column.
- If you have not yet set up column headers, see Make a Header on Google Sheets on PC or Mac.
-
Click the file you want to edit.
-
Double-click the column header you want to change.
-
Use ← Backspace or Delete to remove the current name.
-
Type a new name.
-
Press ↵ Enter or ⏎ Return . The column name is now updated.Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
References
About this article
Thanks to all authors for creating a page that has been read 155,887 times.
Advertisement