Deleting a defined range name?

**gdallas** · 02-17-2010, 07:18 AM

Say i have a range A1:B3 and i define it as "Fruit", but then later decide i want to call it "food", or even just revert back to cell numbers. How would one go about doing this?

Thanks

**Andy Pope** · 02-17-2010, 07:25 AM

Via the macro recorder

Please Login or Register  to view this content.

**teylyn** · 02-17-2010, 07:35 AM

... or, on "foot", click the Name Manager on the formulas ribbon and delete the range name. Select the cells again and assign another name if required.

**stonesy** · 02-17-2010, 07:39 AM

If you go to

Insert - Define - Name (top toolbar)

You will see a list of defined ranges that you can highlight and delete, this will revert them back to cell numbers.

**gdallas** · 02-17-2010, 07:49 AM

Thanks to All, Teylyn's tip worked best for me.

**teylyn** · 02-17-2010, 08:15 AM

Thanks. "Glad to be of service"! -- Douglas Adams

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save