Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default Deleting or Renaming Lists

"Tail Wind" wrote:
I have made a list but I now need to make changes. If I could delete the
list name and associated range (but not the data obviously) I would just
start over.


If you're referring to named / defined ranges,
the options to delete, amend, etc can be accessed
via clicking Insert Name Define

Eg: To delete an named range, just select it within
the Define Name dialog, then click Delete
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tail Wind
 
Posts: n/a
Default Deleting or Renaming Lists

Thank you so much Max. That was sooo easy I'm sick! I just couldn't locate
the solution until you helped out.

Thanks again.


"Max" wrote:

"Tail Wind" wrote:
I have made a list but I now need to make changes. If I could delete the
list name and associated range (but not the data obviously) I would just
start over.


If you're referring to named / defined ranges,
the options to delete, amend, etc can be accessed
via clicking Insert Name Define

Eg: To delete an named range, just select it within
the Define Name dialog, then click Delete
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

  #3   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default Deleting or Renaming Lists

Glad it helped !
Thanks for feedback ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tail Wind" wrote:
Thank you so much Max. That was sooo easy I'm sick! I just couldn't locate
the solution until you helped out.

Thanks again.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compare lists teejay Excel Worksheet Functions 0 January 24th 06 03:30 PM
Counting Entries in two lists MarkN Excel Worksheet Functions 2 November 30th 05 08:15 AM
Excel - need a function to compare lists JerryMatson Excel Worksheet Functions 1 November 24th 05 04:09 PM
renaming copied worksheets deleting .xls] dhl Excel Worksheet Functions 2 July 11th 05 10:55 PM
How to delete duplicate records when I merge two lists (deleting . rinks Excel Worksheet Functions 10 December 11th 04 01:03 AM


All times are GMT +1. The time now is 10:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"