Re: [libreoffice-users] Nested Drop-down List

Are you familiar with Auto Filter?
Highlight all column headers and all the data below -
then select Data - Autofilter.

Is that what you want?
You can set multiple filter criteria in the column header drop-downs.

Select Data - Autofilter again to turn it off, if you want it off.


Mike


On 5/21/22 15:07, users+help@global.libreoffice.org wrote:
> Subject:
> [libreoffice-users] Nested Drop-down List
> From:
> "Vince@Verizon" <wa.tworsx@verizon.net>
> Date:
> 5/21/22, 12:40
>
> To:
> users@global.libreoffice.org
>
>
> Hi:
>
> Hope that all are well.
>
> I am using LO 7.3.2.2 (x64) on desktop Win10 Home.
>
> I want to fine tune a LO Calc file by adding a column that includes a 
> Category drop-down menu, but I find that I might have need for 
> subcategories, in some cases, to avoid a very long list of items.
>
> I recall viewing a tutorial about what I am calling "nested drop-down 
> menu list", whereby if an option in the parent drop-down is selected, 
> a second, a third, ... etc. drop-down list is then opened, if they 
> exist. For example, if one option is utilities, a second drop-down is 
> opened showing, e.g. telephone, electricity, heating fuel, water, 
> etc., as further, optional, selections.
>
> Unfortunately, I cannot recall if the tutorial was for Excel or Apache 
> Open Office or Libre Office.
>
> Can somebody point me to a */Libre Office/* video tutorial or within 
> the LO Help that covers "nested drop down list"? "Nested drop-down 
> menu list" is most probably an incorrect key word text string.
>
> Thanks for reading this.
>
> VinceB.

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy