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.
Numbers alone do not define spreadsheets. Google Drive allows you to also add drawings to a spreadsheet, which can be ...
Discover MoreWhen you create a chart, Sheets helpfully adds a legend to better explain the data that is in the chart. If you don't ...
Discover MoreAdding stock information to a spreadsheet is a common need. Rather than enter information manually, why not let Sheets ...
Discover MoreThere are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Copyright © 2021 Sharon Parq Associates, Inc.
Comments