How to Rename Columns in Google Sheets on PC or Mac
Change the name of a range of cells (Named Range)
How 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 2
Click the file you want to edit.
How 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 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 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 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 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 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 9
Tap the file you want to edit.
How 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 11
Use ← Backspace or Delete to delete the current name.
How 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 13
Press ↵ Enter or ⏎ Return. Column names have now been updated.
You should read it
- Tricks using Google Sheets should not be ignored
- How to create graphs, charts in Google Sheets
- How to align spreadsheets before printing on Google Sheets
- How to enter 0 in Google Sheets
- How to create a phone number can be called on Google Sheets
- How to view editing history on Google Sheets
- 6 useful functions in Google Sheets you may not know yet
- How to fix Google Sheets not allowing scrolling
- How to count words on Google Sheets
- How to set up the right to edit spreadsheets on Google Sheets
- How to write notes, comments on Google Sheets
- How to insert checkboxes on Google Sheets