In Excel, named ranges enable you to describe the formulas entered in cells.

This makes it easier to keep track of related entries in your worksheet.

If you work with named ranges often, you may forget to delete them when you no longer need them.

Named ranges can clutter up your worksheet and make it difficult for others to find the information they need.

You can delete or change unwanted named ranges using the Excel Name Manager.

Delete a Named Range 1 Open Microsoft Excel, then click File and open the document containing the named range you want to delete.

Click the Formulas tab and click Name Manager in the Defined Names group.

Click the name you want to delete.

If you want to delete multiple names in a contiguous group, press the Shift key while clicking each name.

For names in a non-contiguous group, press Ctrl and click each name you want to delete.

Click Delete, then confirm the deletion by clicking OK.

Change a Named Range 1 Launch Microsoft Excel and open the file containing the name you want to replace.

Click the Formulas tab.

Click Name in Manager under the Defined Names heading.

Click the name you want to replace, then click Edit in the Name Manager box.

Enter a new name for the range in the Name box.

Click OK. 5 Change the formula, constant or cell the name represents in the Refers To field in the Name Manager box.

References Microsoft Office: Define and Use Names in Formulas Goucher College: Excel 2007: Calculations Resources Open Forum: Using Excel for Business: 10 Productivity Tips Photo Credits JupiterimagesComstockGetty Images About the Author Melissa King began writing in 2001.

She spent three years writing for her local newspaper, The Colt, writing editorials, news stories, product reviews and entertainment pieces.

She is also the owner and operator of Howbert Freelance Writing.

King holds an Associate of Arts in communications from Tarrant County College.

Related How to Change a Range in Microsoft Excel How to Edit Lists on Microsoft Excel How to Give a Name to the Columns in Excel How to Assign Names to Cells in Excel How to Use Variables in Excel How to Format Relative References in Excel Most Popular How to Add the Difference Range In Excel How to Remove a Name From a Facebook Status Feed How to Create a Chart Hyperlink on iReport How to Rename Columns in Microsoft Excel Queries How to Convert a PowerPoint to an RTF Trending Now 1 How to Change a Range in Microsoft Excel 2 How to Edit Lists on Microsoft Excel 3 How to Give a Name to the Columns in Excel 4 How to Assign Names to Cells in Excel Most Popular 1 How to Use Variables in Excel 2 How to Format Relative References in Excel 3 How to Add the Difference Range In Excel 4 How to Remove a Name From a Facebook Status Feed 5 How to Create a Chart Hyperlink on iReport Logo Return to Top About Privacy Notice Your California Privacy Rights Interest Based Ads Terms of Use Our Company Careers Advertise with Us Ad Choices Contact Customer Service Newsroom Contacts Connect Email Newsletter Facebook Twitter Pinterest Google Instagram Subscribe iPad app HoustonChronicle.com Houston Chronicle Archives eEdition Demo Todays eNewspaper Hearst Newspapers Copyright 2020 Hearst Newspapers, LLC.

Delete Named Range Excel For Mac Vba