Web on the ribbon, click the data tab > data validation.
How to create drop down list in excel ipad. I can’t figure out how to insert a drop down list in a cell. On the first sheet, select cell b1. In the dialog, set allow to list.
If you don't want users to. Place the cursor in the. On the second sheet, create the following named ranges.
This allows you to enter data into a specific cell of a. Simply click the arrow and select an option. On the ribbon, click the data tab, and click data validation.
Web it’s easy and we’ll show you how. I am using excel on my ipad. Web lucilleskipper created on march 29, 2020 creating a drop down list on ipad i can’t figure out how to put a drop down list in a cell using excel on my ipad.
Web drop down list on ipad. Web on the ribbon, click data > data validation.