Open Office Calc
Published on Nov 19, 2012
http://www.bernardotech.org A short tutorial on how to make a drop down list in OpenOffice Calc or OpenOffice Calc.
Visit us on facebook: https://www.facebook.com/BernardoTechHow to make a drop down list in OpenOffice/LibreOffice Calc ...
In this Video we look at how you create drop down lists, as a form of Data Validation using OpenOffice Calc. We also show you how to create your own custom error message to go alongside your drop down list.
Watch More at: https://www.youtube.com/user/theitguys99
Create Multiple Dependent Drop Down Lists
https://www.udemy.com/excel-2010-supe... Create multiple dependent drop down lists in Excel.
It is vital for your Excel reports that data is accurate. Assist users when entering data by providing drop down lists of the possible options. If you have large lists of options then break it down into several cascading drop down lists.
To create multiple dependent drop down lists in Excel you will first need to set up your lists as named ranges. The Data Validation tool and the INDIRECT function can then be used to reference the named ranges creating dependent lists.
Join the Audience: ★ Twitter: http://www.twitter.com/computergaga1 ★Facebook: http://www.facebook.com/computergaga ★ Google + https://plus.google.com/+Computergaga