Changing the name of a list.

C

comotoman

i have created list names next to the formula bar, but i need to edi
the lists (to add more to the list) How do I delete, or change my lis
names
 
S

swatsp0p

If you insert cells (rows or columns) <within> the named range, the
automatically become part of the named range (it auto adjusts th
boundaries of the range).

Alternatively, you can go to Insert on the main menu and choos
Name>Define...

select the desired range from the list and adjust the defined range i
the "Refers to:" box to meet your needs.

HT
 
S

swatsp0p

Glad it worked for you. Thanks for the feedback, it is alway
appreciated.

Cheers!

Bruc
 
Top