Deleting a Named Range

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:

  1. Choose Data | Named and Protected Ranges. Sheets shows the Named and Protected Ranges pane at the right side of the screen.
  2. 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.)

    3. Figure 1. Choosing to edit a named range.

  3. Click the pencil icon. Sheets expands the information about the range. (See Figure 2.)

    4. Figure 2. Changing information about a named range.

  4. Click the Delete Range tool (it looks like a trash can). Sheets asks you to verify that you want to delete the range.
  5. 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. ...

MORE FROM ALLEN

Opening a Workbook and Suppressing Automatic Macros

Want to stop Excel from running any automatic macros that may be stored with a workbook? Here's how to do it.

Discover More

Getting Word to Remember the Default Date and Time Format

One way to insert the current date into your document is to use the Date and Time dialog box. The Default button in the ...

Discover More

Hiding Fonts

Windows makes it easy to manage the fonts installed on your system. One of the lesser-known options is one that allows ...

Discover More
More DriveTips

Brainstorming with Google

Sheets includes a nifty, undocumented feature that allows you to enlist Google's help in brainstorming. All you need to ...

Discover More

Getting Notified of Spreadsheet Changes

Google Sheets makes it easy to receive notifications by e-mail whenever anything in a spreadsheet changes. Here's how to ...

Discover More

Turning Off Gridlines

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
Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is one less than 4?

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)

Links and Sharing
OUR COMPANY
OUR PRODUCTS
OUR AUTHORS
OUR SITES
 

Copyright © 2021 Sharon Parq Associates, Inc.