How to Rename Columns in Google Sheets on PC or Mac
Change the name of a range of cells (Named Range)
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.
Click the file you want to edit.
Click a column letter. This is the letter on the column you want to name. The entire column will be selected.
Click the Data menu . This section is at the top of Sheets.
Click Named ranges . The 'Named ranges' panel will display on the right side of the sheet.
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.
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
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.
Tap the file you want to edit.
Double-click the column header you want to change.
Use ← Backspace or Delete to delete the current name.
Enter a new name.
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
Maybe you are interested
Instructions for quickly aligning Excel printed pages, printing to fit the paper, without losing columns
Excel - Convert columns to rows in Excel
How to delete rows and columns in Excel with mouse or key
Instructions on how to break columns in Word simply and quickly
Column order in Excel is reversed, why and how to handle it?
Excel does not allow inserting additional columns and rows [FIXED]