Follow up ques on using Listings

Z

ZIPPOMA NEEDS HELP

When I go to validate and listing and hit f3 I get a list of listings. How
can I delete listings that are no longer needed or empty?
 
M

Max

When I go to validate and listing and hit f3 I get a list of listings. How
can I delete listings that are no longer needed or empty?
Click to expand...

The defined range's source list has to be edited at source, ie where it is.
You could just click Paste List to see where it is (ensure the adjacent cell
to the right is empty). The better route to maintain defined ranges would be
to click on Insert > Name > Define, select the particular defined range, and
it'll show you where exactly lies the source list in the Refers to box. Go
there, edit the items (eg clear the obsolete source items, etc), then go back
to Insert > Name > Define to edit the shortened range in the Refers to box.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:61
xdemechanik
---
 
Z

ZIPPOMA NEEDS HELP

Thanks Max Got it
--
Thanks Everyone
Mike


Max said:
The defined range's source list has to be edited at source, ie where it is.
You could just click Paste List to see where it is (ensure the adjacent cell
to the right is empty). The better route to maintain defined ranges would be
to click on Insert > Name > Define, select the particular defined range, and
it'll show you where exactly lies the source list in the Refers to box. Go
there, edit the items (eg clear the obsolete source items, etc), then go back
to Insert > Name > Define to edit the shortened range in the Refers to box.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:61
xdemechanik
---
Click to expand...
 
Top