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. 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.
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. 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.
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.
Comments
0 comment