On the named range you want to edit or delete, click Edit.For example, you might get an error if you give your range a name like "A1:B2" or "R1C1:R2C2." Can't contain any spaces or punctuation.Can't start with a number, or the words "true" or "false.".Can contain only letters, numbers, and underscores.Select a range in the spreadsheet or type the new range into the text box, then click Ok.To change the range, click Spreadsheet.Tip: To quickly open this menu, in the range box on the top left, click the drop down menu > Manage named ranges. You can name ranges in Google Sheets to keep better track of them and create cleaner formulas.įor 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
0 kommentar(er)
