Adjust Dropdown Text For Free

The length of the drop-down box is not big enough to display the entire text. The simple solution is to widen the column that the drop-down box is in. You can adjust the column manually by dragging the border of the column header.

By default, a data validation drop-down list only shows 8 items in the list when clicking the drop-down arrow. So you need to drag the scroll bar down for viewing more values in the list. Actually, you can show more than 8 lines in a drop-down list with the help of Combo box.

Condense a list to have no blanks with filtering and copyingSelect the list you want to condense, and then click Data > Filter.Then a drop-down arrow is added to the first cell of the list, click the arrow, and uncheck the (Blanks) box, then click the OK button.More items...

Select the numbers you need to abbreviate, and right click to select Format Cells from the context menu. 3. Click OK to close dialog, now the large numbers are abbreviated. Tip: If you just need to abbreviate the large number as thousand K or million M, you can type #,"K" or #,,"M" into the textbox.

Narrowing a drop-down list based on values provided in adjacent...Create three or more list in the spreadsheet.Select the cell where you want the initial validation list, for this example, D1.Choose Data, Validation.From the Allow drop-down and choose List.In the Source box enter the following formula.More items...?Jun 28, 2010

Show activity on this post.Select the entire column you want to validate.Click on "Data Validation" from the Data tab.Choose "List" from the "Allow" box.Click on the arrow to the right of the "Source" box and select the cells containing the allowed values.Mar 15, 2015

Add data validation to a cell or a rangeSelect one or more cells to validate.On the Data tab, in the Data Tools group, click Data Validation.On the Settings tab, in the Allow box, select List.In the Source box, type your list values, separated by commas.Make sure that the In-cell dropdown check box is selected.More items...