Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / January 2006

Tip: Looking for answers? Try searching our database.

Data - Validation Excel Question?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mike - 31 Jan 2006 15:19 GMT
Hi everyone,

Say you are using Data -> Validation -> List where you add options like
this 1,2,3,4

Assume now you are doing this for every single cell in a matrix 5X5 for
example.

At one point, you want all cells in the matrix to be blank. I tried
this for each cell: 1,2, , 3,4

But when I tried it, it did disregard the blank option!!? How can I
overcome that?

Also, how can I automate that so I don't have to do this for every
single cell (blank case only?

Thanks,
Mike
Paul Mathews - 31 Jan 2006 22:42 GMT
Hi Mike,

If I understand correctly, you'd like the cell choices in your matrix to be
1,2,3,4, or blank.  When you create your validation list, I think all you
need to do is ensure that the "Ignore blank" check box is checked on (your
validation list would just be the usual "1,2,3,4").  If you truly want to
change one of the current numerical entries in your matrix to a blank, just
place focus on the cell and hit your delete key (since the validation will
permit blanks).  The other possible way to do this would be to set a
validation list of "0,1,2,3,4" and then open the Tools|Options dialogue box,
select the "View" tab, and then uncheck "Zero values".  In this case, if you
choose a zero value from the validation list in any cells in the matrix, it
will actually display as blank.  The only caveat with this approach is that
it will affect the entire worksheet in which your validation matrix is
located (so, if you want to see potential zero values outside of your matrix,
this wouldn't be the way to go).  Hope this helps.

Paul

> Hi everyone,
>
[quoted text clipped - 15 lines]
> Thanks,
> Mike
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.