"Nested" or "Cascading" Pop-Up Menus in Numbers New Version

Here is a method to create "nested" or "cascading" Pop-Up Menus.

In a single table, we shall use a Filter to show only those rows that include second level choices that "cascade" from each first level choice.

Suppose that you want to choose an animal (for example, Cat) in the first level of cascading Pop-Up Menus, and then choose a breed or species of that animal (for example Cat, Persian) in the second level of cascading Pop-Up Menus.

Start with a table with all cells formatted as Automatic:

Now convert one row at a time to Pop-Up Menus.

In one row at a time, select only those cells that contain text.

With those cells selected, convert the Data Format to Pop-up Menu.

Do not select blank cells. We don't need them.

Do not select all cells in the table at once; that will create a monster Pop-Up Menu!

• Delete all columns except for columns A and B.
• Select all of column B and delete the contents.
• Set the Data Format of column B to Automatic.
• Type "Show" (without the quote marks) into B1. We need B1 to always be on show when we apply the filter!

Formula in B2: IF(A$1="Cat","Show","")

Formula in B3: IF(A$1="Dog","Show","")

Formula in B4: IF(A$1="Lizard","Show","")

Now for the Filter: Column B > Text is "Show"

Choose an Animal:

You can hide Column B.

Rest assured that it took me much longer to describe than it will take to implement!

Regards,

Ian.