Can you name a range?

Name a range of cellsYou can name ranges in Google Sheets to keep better track of them and create cleaner formulas. For example, instead of using "A1:B2" to describe a range of c

Can you name a range?

Name a range of cells

You can name ranges in Google Sheets to keep better track of them and create cleaner formulas.

For example, instead of using "A1:B2" to describe a range of cells, you could name the range "budget_total." This way, a formula like "=SUM(A1:B2, D4:E6)" could be written as "=SUM(budget_total, quarter2)."

Name a range

  1. Open a spreadsheet in Google Sheets.
  2. Select the cells you want to name.
  3. Click Data
and then

Named ranges. A menu will open on the right.
   
   Tip:To quickly open this menu, in the range box on the top left, click the drop down menu

Down arrow

>Manage named ranges.

  1. Type the range name you want.
  2. To change the range, click Spreadsheet
Grid

.

  1. Select a range in the spreadsheet or type the new range into the text box, then click Ok.
  2. Click Done.

Range names:

  • Can contain only letters, numbers, and underscores.
  • Can't start with a number, or the words "true" or "false."
  • Can't contain any spaces or punctuation.
  • Must be 1250 characters.
  • Can't be in either A1 or R1C1 syntax. For example, you might get an error if you give your range a name like "A1:B2" or "R1C1:R2C2."

Edit or delete a named range

  1. Open a spreadsheet in Google Sheets.
  2. Click Data
and then

Named ranges.

  1. On the named range you want to edit or delete, click Edit
Edit

.

  1. To edit the range, enter a new name or range, then click Done.
  2. To delete the named range, next to the name, click Delete range
Delete

.

  1. On the menu that opens, click Remove.

Note: When you delete a named range, any formulas that reference it will no longer work. Protected ranges that reference a named range will use the cell values and continue to work.                  Computer AndroidiPhone & iPad   More

Need more help?

Try these next steps:

Ask the Help Community Get answers from community experts

Video liên quan