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:
- Choose Data | Named and Protected Ranges. Sheets shows the Named and Protected Ranges pane at the right side of the screen.
- Hover the mouse pointer over the named range you want to delete. A small pencil icon appears at the right of the range name. (See Figure 1.)
Figure 1. Choosing to edit a named range.
- Click the pencil icon. Sheets expands the information about the range. (See Figure 2.)
Figure 2. Changing information about a named range.
- Click the Delete Range tool (it looks like a trash can). Sheets asks you to verify that you want to delete the range.
- Click Remove. The named range is deleted.
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.
Author Bio
Allen Wyatt
With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. Learn more about Allen...
Converting Tables to Charts
Put numeric information in a table and you can then convert that information to a graphical chart using Microsoft Graph ...
Discover More
Determining Picture Size in a Macro
When processing a document using a macro, you may need for your macro to figure out the sizes of the images in your ...
Discover More
Expiration Date for Excel Programs
If you use Excel to create a macro-based application, you may want to make sure that your programs cease working after a ...
Discover More
Adding a Drawing to Your Spreadsheet
Numbers alone do not define spreadsheets. Google Drive allows you to also add drawings to a spreadsheet, which can be ...
Discover More
Saving a Spreadsheet Locally in a Non-Sheets Format
Need to share your spreadsheet with others who may not be using Google Sheets? Here's an easy way to export your ...
Discover More
Grading Assignments with Flubaroo
Flubaroo is a third-party extension for Sheets that can help make grading classroom papers fast and easy. Here's a quick ...
Discover More
Comments