Named Cells (Ranges)

  • Thread starter Thread starter Derek Hart
  • Start date Start date
D

Derek Hart

If I name a cell, and want to change the name, in Excel 2003, there is no
easy way to do it. Do I have to delete the name, and add back a new one?
Very tedious...
 
Hi,

Actually you don't need to delete the old range name, just add the new name.
A range can have as many names as you like. Of course that clutters up the
list, but you can come back at some later time and delete unwanted names.
 
Just to add...

Be careful before you delete the old names. You'll want to change anything that
uses them--formulas, other names, VBA code...
 
That's one way to slow your workbook down, seeing as the redundant names
will all get recalculated every time.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Named range with multiple groups of cells 4
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
2007 Macro to Open File, Delete Contents, Save New File 2
Excel JUMP FROM SEARCH BAR TO RESULT 3
How To Use Range Names In Data Validation Criteria (Not For Lists) 1
Can't located named range 3

Back
Top