Open Office Calc: Difference between revisions
(Created page with "How to make a drop down list in OpenOffice/LibreOffice Calc ... {{#ev:youtube|9i_-ErFVffs|300|right|drop down list}}") |
mNo edit summary |
||
| (3 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
{{#ev:youtube|9i_-ErFVffs|300|right|drop down list 1:16 minutes}} | |||
{{#ev:youtube| | 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 ... | |||
---- | |||
{{#ev:youtube|02VQZ0kteAk|300|right|drop down list 5:07 minutes}} | |||
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 | |||
---- | |||
{{#ev:youtube|5nb84p2wX-c|300|right|Create Multiple Dependent Drop Down Lists 10:39 minutes}} | |||
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 | |||
[[Category:DIY]] | |||
Latest revision as of 07:37, 24 October 2023
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