Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
In Excel, in the top corner of the application there is a
box which list the name of a select range (e.g F19 etc..). when I use the querytables method to import a CSV onto a worksheet. This range address box, has the name of the data I have imported. when I use clear, or qyertytables delete to remove the imported data - I am unable to remove the name of the data appearing in the drop-down list for the range box. Is there anyway to delete this ? or is it not a problem ? I am concerned because I this rangelist seems to fill up pretty quickly with imported data ranges.. |
#2
![]() |
|||
|
|||
![]()
Choose InsertNameDefine
Select a name in the list Press the Delete key If you're working with names, you might like the Name Manager, a free add-in that makes it easy to work with defined names. You can download a copy: http://www.bmsltd.ie/MVP/Default.htm It allows you select and delete multiple names Satnam Patel wrote: In Excel, in the top corner of the application there is a box which list the name of a select range (e.g F19 etc..). when I use the querytables method to import a CSV onto a worksheet. This range address box, has the name of the data I have imported. when I use clear, or qyertytables delete to remove the imported data - I am unable to remove the name of the data appearing in the drop-down list for the range box. Is there anyway to delete this ? or is it not a problem ? I am concerned because I this rangelist seems to fill up pretty quickly with imported data ranges.. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
![]() |
|||
|
|||
![]()
(I cancelled my previous message, because the link wasn't working)
Choose InsertNameDefine Select a name in the list Press the Delete key If you're working with names, you might like the Name Manager, a free add-in that makes it easy to work with defined names. You can download a copy from Jan Karel Pieterse's site: http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.htm It allows you select and delete multiple names Satnam Patel wrote: In Excel, in the top corner of the application there is a box which list the name of a select range (e.g F19 etc..). when I use the querytables method to import a CSV onto a worksheet. This range address box, has the name of the data I have imported. when I use clear, or qyertytables delete to remove the imported data - I am unable to remove the name of the data appearing in the drop-down list for the range box. Is there anyway to delete this ? or is it not a problem ? I am concerned because I this rangelist seems to fill up pretty quickly with imported data ranges.. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
![]() |
|||
|
|||
![]()
Although, bsmltd.ie still exists, I think this is the preferred site:
http://www.oaltd.co.uk/mvp Debra Dalgleish wrote: Choose InsertNameDefine Select a name in the list Press the Delete key If you're working with names, you might like the Name Manager, a free add-in that makes it easy to work with defined names. You can download a copy: http://www.bmsltd.ie/MVP/Default.htm It allows you select and delete multiple names Satnam Patel wrote: In Excel, in the top corner of the application there is a box which list the name of a select range (e.g F19 etc..). when I use the querytables method to import a CSV onto a worksheet. This range address box, has the name of the data I have imported. when I use clear, or qyertytables delete to remove the imported data - I am unable to remove the name of the data appearing in the drop-down list for the range box. Is there anyway to delete this ? or is it not a problem ? I am concerned because I this rangelist seems to fill up pretty quickly with imported data ranges.. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Dave Peterson |
#5
![]() |
|||
|
|||
![]()
Hi Debra,
The link still works for me (?), but Stephen's site is now http://www.oaltd.co.uk/MVP/Default.htm -- HTH Bob Phillips "Debra Dalgleish" wrote in message ... (I cancelled my previous message, because the link wasn't working) Choose InsertNameDefine Select a name in the list Press the Delete key If you're working with names, you might like the Name Manager, a free add-in that makes it easy to work with defined names. You can download a copy from Jan Karel Pieterse's site: http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.htm It allows you select and delete multiple names Satnam Patel wrote: In Excel, in the top corner of the application there is a box which list the name of a select range (e.g F19 etc..). when I use the querytables method to import a CSV onto a worksheet. This range address box, has the name of the data I have imported. when I use clear, or qyertytables delete to remove the imported data - I am unable to remove the name of the data appearing in the drop-down list for the range box. Is there anyway to delete this ? or is it not a problem ? I am concerned because I this rangelist seems to fill up pretty quickly with imported data ranges.. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula to return ADDRESS of cell in range that meets criteria | Excel Worksheet Functions | |||
range names | Excel Worksheet Functions | |||
How do I use Range Names listed in a VLookup table in a formula? | Excel Worksheet Functions | |||
range names | Excel Worksheet Functions | |||
range names | Excel Worksheet Functions |