Reuse: Quickly insert complex formulas, charts and anything that you have used before Encrypt Cells with password Create Mailing List and send emails.The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by Click for full-featured free trial inģ00 handy Excel add-ins, free to try with no limitation in Kutools for Excel has a powerful utility - Batch Insert Check Boxes / Batch Insert Option Buttons can insert checkboxes/buttons into the selected cells with one click. In Excel, you only can insert one checkbox/button into a cell once time, it will be troublesome if there are multiple cells needed to be inserted checkboxes/buttons at the same time. Quickly Insert multiple checkboxes or buttons into a range of cells in worksheet Now a drop down list with symbol you want has been created. In the Data Validation dialog, under Settings tab, select List from Allow section, and the select the symbol cells into Source textbox. Select a cell or a range you want to place the drop down list, and click Data > Data Validation. Now you can create a drop down list with these symbols. Then type the symbol you need with above step one by one to the cells. Select a cell and then hold Alt key, and type 30 in the Number keyboard to insert symbol ▲. Here is some common-used symbols you may use in drop down list:ġ.

To insert symbol in Data Validation list, you can use numbers + Alt to do a favor. Create drop down list with symbol in Excel

Drop down computer arrow symbol