by Allen Wyatt
(last updated February 6, 2014)
Named ranges can be a powerful tool that aids in the quick (and understandable) development of formulas in a spreadsheet. However, as a spreadsheet changes, you may no longer have need for a named range that you previously defined. If you want to get rid of a named range, follow these steps:
Figure 1. Choosing to edit a named range.
Figure 2. Changing information about a named range.
Remember that deleting a named range doesn't actually delete any data in your spreadsheet. All it does is to get rid of the name you previously created. If you have any formulas in your spreadsheet that use the name you just deleted, those formulas will need to be edited so they are correct.
Sheets includes a nifty, undocumented feature that allows you to enlist Google's help in brainstorming. All you need to ...Discover More
Google Sheets makes it easy to receive notifications by e-mail whenever anything in a spreadsheet changes. Here's how to ...Discover More
The purpose of gridlines is to make it easy to identify and select cells in a spreadsheet. If you find the gridlines to ...Discover More