L
Lynn McGuire
I created several lists in a spreadsheet that
I am not using. Does anyone know how to delete
these lists in Excel 2003?
Thanks,
Lynn
I am not using. Does anyone know how to delete
these lists in Excel 2003?
Thanks,
Lynn
I created several lists in a spreadsheet that
I am not using. Does anyone know how to delete
these lists in Excel 2003?
Thanks,
Lynn
I created several lists in a spreadsheet that
I am not using. Does anyone know how to delete
these lists in Excel 2003?
Thanks,
Lynn
To delete the list:
If you created these lists using the *List* menu then I think you just need to delete the cells containing the list data. This would
be all cells within the list border.
To *unlist* the data:
Alternativly, you can convert the list to a normal range and leave the data or clear the contents of the cells. You can do this via
the *List* menu.
The only thing in my *Data/List* menu is the entries
"Create List..." and "Hide Borders of inactive Lists".
Thanks,
Lynn
After serious thinking Lynn McGuire wrote :
Then no *Lists* exist. You only get the other menuitems if the active worksheet contains *Lists* created via the *Create List...*
menuitem.
worksheet contains *Lists* created via the *Create List...*
F5, the goto dialog, shows six different lists.
How do I delete these ?
F5, the goto dialog, shows six different lists.
How do I delete these ?
I'm hinking same as Bruce. Items that appear in this dialog are typically named ranges that can be deleted in the *defineName* dialog.
That worked!
The dialog was at "Insert / Name / Define...".
Not obvious at all in Excel 2003.
Thanks,
Lynn
Lynn McGuire wrote :
Lynn,
Glad you got a solution. Sorry for not being more explanatory on where/how to open the DefineName dialog! (I assumed you were
familiar enough using Excel to know this; ..my bad!<g>)
Like most users of Excel, I am familiar with the
20% of it that I use. Nowhere near the power
user that I used to be with 1-2-3 but I have no
need to be.
Now, if you want to know about C++/OLE usage and
Excel, I'm your man.
Thanks,
Lynn
named ranges that can be deleted in the *defineName* dialog.
That worked!
The dialog was at "Insert / Name / Define...".
Not obvious at all in Excel 2003.
When the "ribbon' arrived, obvious left the building.
My solution is to minimise the thing and put everythign I need in my quick
bar. Now ...to find a double line version of that.
Glad you got it sorted.
Bruce Sinclair formulated the question :
Initially, I used J-Walk's code to create the older Excel menus in
XL2007 and used only the Addins tab. After I got familiar with where
things were I don't create the older menus anymore!<g>
hide it, ctrl/F1 or the pointer beside the ? at the far rightBruce Sinclair said:My major objection tothe ribbon was the waste space it created at the top
of my docs. I tried to move it to the side ... but no, we can't even move
it where we want it. Inconceivable !
My major objection tothe ribbon was the waste space it created at the top
of my docs. I tried to move it to the side ... but no, we can't even move
it where we want it. Inconceivable !
hide it, ctrl/F1 or the pointer beside the ? at the far right
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.