Numbers pop up manu

Hi warunasanjeewa,

Start with this table

Select one column at a time and Format Panel > Data Format > Pop-Up Menu.

Do not select blank cells, or you will get blank entries in your Pop-Ups.

Copy A1 and paste into A1 of another table (I named it Cascading Pop-Ups)

Copy B1 of Machines and paste into Cascading Pop-Ups A2

Copy C1 of Machines and paste into Cascading Pop-Ups A3

And so on.

In B1 of Cascading Pop-Ups, type Show.

Formula in B2 of Cascading Pop-Ups: IF(A$1="Kobelco","Show","")

Formula in B3 of Cascading Pop-Ups: IF(A$1="Komutsu","Show","")

Formula in B4 of Cascading Pop-Ups: IF(A$1="JCB","Show","")

Formula in B5 of Cascading Pop-Ups: IF(A$1="Caterpillar","Show","")

Apply a filter to the Cascading Pop-Ups table:

To see this:

Now choose a manufacturer

Choose a Caterpillar product

You can hide Column B.

Regards,

Ian.

This has been a recurring topic over the years. But Numbers still does not directly support cascading menus.

Yellowbox and others have posted workarounds. Perhaps they will chime in.

You can provide feedback to Apple via Numbers > Provide Numbers Feedback in your menu.

SG

Hi warunasanjeewa,

I am happy to help.

Thank you for the gold star and green tick.

Keep posting in Numbers for Mac. You will find many helpful people here.

Regards,

Ian.