Data Validation Using DropDown List – LibreOffice Calc

By | December 31, 2019

This tutorial would show how to use a basic range based data validation in LibreOffice Calc using a drop down list.

While accepting data in a Calc sheet, it is possible to provide the user a choice of items in a form of a drop-down list. Users can select the desired value from the drop-down instead of custom text. This eliminates the possibility of error, duplicate in the data entry/collection process.

Let’s look at how this can be done using an example.

Data Validation using Dropdown

Say, we want users to select their favorite fruits in cell B1 from a list of fruits which is F1:F4.

Data Validation from List - Source
Data Validation from List – Source

Select cell B1 and from the menu select Data -> Validity.

In the Validity window, Criteria tab, select “Cell Range” against Allow field.

Check Show selection list and un-check allow empty cells.

SEE ALSO:  IF Function in LibreOffice Calc - Basics and Examples

In the source field, click the small Shrink button at the right and select the F1:F4 range.

Validity Settings
Validity Settings
Select Range as Source
Select Range as Source

Press Ok.

Results

In cell B1, you can see a small down-arrow button. Click the button and the drop-down would show the list of values from the source range.

Now, you can select a value from the drop-down list.

Data Validation - List
Data Validation – List

If the user wants to type a different value in cell B1, the data validation would give an error by default saying it is an invalid value.


For the latest tutorials, news and how-to guides, follow libreofficehelp.com on Twitter, Facebook, and subscribe to our YouTube channel and email updates via below form.

Join 565 other subscribers.