Related Articles
Apr 22, 2013 Therefore on a Mac it's, fn+command+F3 - Looks like the 'fn' button makes the F1-F12 keys act like windows function keys, and cntrl becomes command as per usual. SO, on Mac 2011 excel, Press 'fn+command+F3' to see the name manager. Remember, saying thanks only takes a. Step # 1 – Entering the range name. In this Ms Excel tutorial, we will start off the process by giving the cell range a name. In order to do so, highlight the cells that you want to name and go to the name box which is situated on the left side of the screen.
- 1 Change a Range in Microsoft Excel
- 2 Give a Name to the Columns in Excel
- 3 Assign Names to Cells in Excel
- 4 Edit Lists on Microsoft Excel
Microsoft Excel helps your business organize finances, including bills, taxes and customer invoices. 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.
2.Click the 'Formulas' tab and click 'Name Manager' in the Defined Names group. A window opens that contains a list of all the named ranges in the document.
3.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.
4.Click 'Delete,' then confirm the deletion by clicking 'OK.'
Change a Named Range
1.![How To Name A Range In Excel Mac How To Name A Range In Excel Mac](/uploads/1/2/4/7/124744178/432679490.jpg)
Launch Microsoft Excel and open the file containing the name you want to replace.
2.Click the 'Formulas' tab. Click 'Name in Manager' under the Defined Names heading.
3.Click the name you want to replace, then click 'Edit' in the Name Manager box.
4.Enter a new name for the range in the Name box. Change the reference for the name in the Refers To box. Click 'OK.'
5.![Excel Excel](/uploads/1/2/4/7/124744178/989336085.png)
Change the formula, constant or cell the name represents in the Refers To field in the Name Manager box. Click 'Commit' to accept the changes.
References (2)
Resources (1)
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.
Cite this Article Choose Citation Style
King, Melissa. 'How to Delete a Named Range in Excel.' Small Business - Chron.com, http://smallbusiness.chron.com/delete-named-range-excel-49298.html. Accessed 18 June 2019.
King, Melissa. (n.d.). How to Delete a Named Range in Excel. Small Business - Chron.com. Retrieved from http://smallbusiness.chron.com/delete-named-range-excel-49298.html
King, Melissa. 'How to Delete a Named Range in Excel' accessed June 18, 2019. http://smallbusiness.chron.com/delete-named-range-excel-49298.html
Note: Depending on which text editor you're pasting into, you might have to add the italics to the site name.