Re: [libreoffice-users] how to put only two options in a dropdown

At 11:53 28/02/2016 -0600, Beau Thompson wrote:
> I have a project that needs a dropdown box on the data sheet E1 I 
> like the data from B1 and B16 with this i get all $data.$B$1:$B$16

Easy: you need to define an intermediate cell range for your 
drop-down list. Enter =B1 and =B16 in two neighbouring cells in some 
convenient place and then use the range of those two cells for Source 
in the Validity panel instead of the original cells. Using references 
like this instead of copying the original values has the advantage 
that any changes you later make to the values in B1 or B16 are 
automatically reflected in the intermediate range.

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted