Letter Insert Dropdown List For Free

Create a drop-down listSelect the cells that you want to contain the lists.On the ribbon, click DATA > Data Validation.In the dialog, set Allow to List.Click in Source, type the text or numbers (separated by commas, for a comma-delimited list) that you want in your drop-down list, and click OK.

Follow these steps:Select the columns to sort.In the ribbon, click Data > Sort.In the Sort popup window, in the Sort by drop-down, choose the column on which you need to sort.From the Order drop-down, select Custom List.In the Custom Lists box, select the list that you want, and then click OK to sort the worksheet.

To add a custom field into the body of your email, click + Text Field, add in the field name, and press OK to insert. To add a drop down menu, click the +Dropdown button, fill in the field and menu options, and press OK.

Creating the Drop Down ListSelect the range of cells where we wish the drop down list to appear, and then in the Ribbon, select Data > Data Validation.Now select List from the Allow list, then type the formula for the Source of the list.Click OK to create the sorted drop down list in the selected range.

In the Sort By options, select Paragraphs from the first dropdown, and then select Text from the Type dropdown. Click the Ascending option to sort from A to Z, or Descending to sort from Z to A. When you've got it all set up, click the OK button. And just like that, your text is alphabetized.

Though it is not possible to create a dropdown box directly in an email message, nothing prevents you from creating it in Word, and then simply copying to Outlook.

Select the cells which contain the drop down lists you have already created, and then click Data > Data Validation > Data Validation. See screenshot: 2. In the Data Validation dialog box, uncheck the Show error alert after invalid data is entered box under Error Alert tab, then click the OK button.