You are viewing the article How to Rename Columns in Google Sheets on PC or Mac at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 2,567 times.
This wiki page will show you different ways to change column names in Google Sheets on desktop. You can edit the name used to reference the column in the formula or change the column header name.
Steps
Change the name of a range of cells (Named Range)
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/d4/Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-1.jpg/v4- 728px-Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-1.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/d/d4/ Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-1.jpg/v4-728px-Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-1. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Visit 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 (for example, “Budget” replaces “D1:E10”) that you can use to reference it in a formula. [1] X Research Source
- To change the name that appears in the header at the top of a column, refer to this method.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a2/Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-2.jpg/v4- 728px-Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/a2/ Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-2.jpg/v4-728px-Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-2. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the file you want to edit.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/b8/Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-3.jpg/v4- 728px-Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/b8/ Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-3.jpg/v4-728px-Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Tap a column letter. This is the letter on the column you want to name. The entire column will be selected.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/31/Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-4.jpg/v4- 728px-Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/31/ Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-4.jpg/v4-728px-Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-4. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the Data menu. This section is at the top of Sheets.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c6/Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-5.jpg/v4- 728px-Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c6/ Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-5.jpg/v4-728px-Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-5. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Named ranges . The “Named ranges” panel will display on the right side of the sheet.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/b4/Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-6.jpg/v4- 728px-Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-6.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/b4/ Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-6.jpg/v4-728px-Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-6. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
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. [2] X Research Source
- 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.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/69/Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-7.jpg/v4- 728px-Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-7.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/69/ Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-7.jpg/v4-728px-Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-7. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
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
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/d8/Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-8.jpg/v4- 728px-Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-8.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/d/d8/ Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-8.jpg/v4-728px-Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-8. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Visit 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 before, refer to it.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/0d/Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-9.jpg/v4- 728px-Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-9.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/0d/ Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-9.jpg/v4-728px-Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-9. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Tap the file you want to edit.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/02/Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-10.jpg/v4- 728px-Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-10.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/02/ Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-10.jpg/v4-728px-Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-10. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Double-click the column header you want to change.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/bf/Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-11.jpg/v4- 728px-Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-11.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/bf/ Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-11.jpg/v4-728px-Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-11. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Use ← Backspace or Delete to delete the current name.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/6a/Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-12.jpg/v4- 728px-Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-12.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/6a/ Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-12.jpg/v4-728px-Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-12. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Enter a new name.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/77/Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-13.jpg/v4- 728px-Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-13.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/77/ Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-13.jpg/v4-728px-Rename-Cpumns-on-Google-Sheets-on-PC-or-Mac-Step-13. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Press ↵ Enter or ⏎ Return . Column names have now been updated.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 2,567 times.
This wiki page will show you different ways to change column names in Google Sheets on desktop. You can edit the name used to reference the column in the formula or change the column header name.
Thank you for reading this post How to Rename Columns in Google Sheets on PC or Mac at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: