Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Changing the name of a list.
i have created list names next to the formula bar, but i need to edit the lists (to add more to the list) How do I delete, or change my list names? -- comotoman ------------------------------------------------------------------------ comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292 View this thread: http://www.excelforum.com/showthread...hreadid=468324 |
#2
|
|||
|
|||
If you insert cells (rows or columns) <within the named range, they automatically become part of the named range (it auto adjusts the boundaries of the range). Alternatively, you can go to Insert on the main menu and choose NameDefine... select the desired range from the list and adjust the defined range in the "Refers to:" box to meet your needs. HTH -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=468324 |
#3
|
|||
|
|||
This works very nice, thanks very much. -- comotoman ------------------------------------------------------------------------ comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292 View this thread: http://www.excelforum.com/showthread...hreadid=468324 |
#4
|
|||
|
|||
Glad it worked for you. Thanks for the feedback, it is always appreciated. Cheers! Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=468324 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Unpivot Technique" - Changing a Table Into A List | Excel Discussion (Misc queries) | |||
Changing the color of a list entry based on a tolerance | Excel Worksheet Functions | |||
MRU list - entries keep changing | Excel Discussion (Misc queries) | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Changing font size in a list box | Excel Discussion (Misc queries) |