Deleting range names

You can delete any range name in the sheet, leaving the data in the range unchanged.

  1. In the action bar, click Range.

  2. In the pop-up menu, click Name.

  3. Click the list of existing range names, and then click the name of the range you want to delete.

  4. Click Delete.

  5. (Optional) To delete another range name, repeat steps 3 and 4.

  6. Click Done.



Details

If you delete a range name used in a formula, your spreadsheet replaces the range name with the associated range address. For example, if SALES is the name of B14..H14, and you delete the name SALES, your spreadsheet changes @SUM(SALES) to @SUM(B14..H14).



See also
Naming a range