create a drop down list in excel 2011 mac

#CREATE A DROP DOWN LIST IN EXCEL 2011 MAC PDF#
#CREATE A DROP DOWN LIST IN EXCEL 2011 MAC FREE#

From the Add Effects drop-down list choose Entrance.

Then, choose Custom Animation from the Animations group. In PowerPoint 2007, click the Animations tab.

Choose Custom Animation from the Slide Show menu.

Now you’re ready to add the animation that will display the submenus when someone clicks the Go To button. Figure D Group the submenus so you can animate them as a group. Then, right-click the selection, choose Grouping from the resulting context menu, and choose Group, as shown in Figure D. Select them all (don’t select Goto) by holding down while you click each submenu. To get all of the submenus to drop down together, you must group them. Figure C Submenus direct users to specific slides.

#CREATE A DROP DOWN LIST IN EXCEL 2011 MAC FREE#

Viewers are free to choose the information they want to view. Add text for each and format as necessary. Repeat step 3 to add the remaining submenus. Figure B Choose a smaller AutoShape for the submenu. Add the appropriate text, as shown in Figure B. Position it under the main menu AutoShape (Go To, in this case). Next, add the first submenu using an appropriate AutoShape. Figure A This AutoShape represents the drop-down menu’s main or top level. You can also change the font, size, and weight. To add text, right-click the shape and choose Add Text. Then, add the appropriate text, as shown in Figure A. To this slide, add an AutoShape for the main menu by choosing Basic Shapes from the AutoShapes drop-down list, clicking a shape, and then clicking in the slide. You’ll need a clean slide for your main menu and in most cases, it’ll be the first slide in the presentation. If you truly need submenus, consider creating a main menu slide that links to a choice of submenus, rather than trying to fit them all onto one slide. Menu items can have submenus, and those submenus can have submenus, but simple is best. That means the menu must clearly represent the direction or subset.

The point is to allow users to choose a specific slide or a subset of slides to view instead of forcing them to sit through a linear presentation. If the presentation is complex enough, you might use flowchart software.

#CREATE A DROP DOWN LIST IN EXCEL 2011 MAC PDF#

Note: This article is also available as a PDF download. The example in this article, which you can build in 10 easy steps, is simple by design, so as not to confuse the technique with the possibilities. Then, you add a bit of animation so that the drop-down menu’s submenus seem to drop down from a main menu when clicked. The technique is simple really: You combine AutoShapes to build a drop-down menu type group. The latter is easier to implement and doesn’t require the skill level that programming does. You can spend a lot of time programming objects, or you can use animation. With a little animation sleight of hand, you can create a menu that allows viewers to navigate a self-running slide show.Īdding a drop-down menu to a primary or introductory slide is a good way to give viewers a bit of control over a self-running presentation. 10 steps to adding a drop-down menu to a PowerPoint presentation

Create a drop down list in excel 2011 mac