However, after naming a cell, it seems like Excel won't let you delete or change the name! Because if you click in the Name Box and type over the name or delete the name, NOTHING HAPPENS!
How to Delete Cell and Range Contents in Excel for Mac The trick is to remember that fn+Delete is really a keyboard shortcut to the Delete key on a Mac. Then the world rights itself and the planets align.
And Excel Help doesn't seem to help. So, how do I change or delete a cell name in an Excel spreadsheet? It's pretty easy. It's just hidden! So open your Excel spreadsheet and follow the directions below.
To Change a Cell Name 1. Click the Formulas tab at the top of the worksheet. Then click Name Manager on the 'Defined Names' section of the ribbon. The Name Manager window displays and lists ALL of the cell names that have ever been defined in the worksheets in that workbook. Click on the cell name that you want to change, and click the Edit button.
The Edit Name window displays. Retype the name and click OK. When finished, click Close on the Name Manager window. To Delete a Cell Name 1. Click the Formulas tab at the top of the worksheet. Then click Name Manager on the 'Defined Names' section of the ribbon. The Name Manager window displays and lists ALL of the cell names that have ever been defined in the worksheets in that workbook.
Click on the cell name that you want to delete, and click Delete button. Click OK on the 'are you sure' popup and then click Close on the Name Manager window. By the way, our main tutorial website has just had an exciting makeover! Besides our popular beginner's tutorials such as and, we've added some new tutorials to our 'Fabulous' series. We've added more tutorials covering Excel's built-in functions. If a group of cells are in rows or columns that have headings (and this only works on the cells that are adjacent to the headings!) you can use the 'Create from Selection' button on the Formulas tab. Microsoft has a tutorial on it.
![Delete Delete](/uploads/1/2/5/5/125520924/563732074.png)
But I'm not crazy about it because it only works for the cells that are right next to the headings and then Excel uses the headings text to create the cell names with some underscores thrown in. I am usually working on complex, small worksheets, so I guess this could be useful for someone working on gigantic sheets.