

Search drop-down list: This feature helps create a searchable drop-down list. If you enable this feature, you can check the boxes to select multiple items from drop-down lists. Multiple choice drop-down list: After enabling this feature, you can select multiple items from drop-down lists in the specified data validation area (drop-down list).ĭrop-down list with checkboxes: This feature adds a checkbox in front of each drop-down list in the data validation area (drop-down list). See also Grammarly 1.0.21.343 Crack License Code Download Sort/choose rank randomly: It can quickly sort cells in a random range, randomly sort cells based on each row or column, randomly sort entire rows or columns, and randomly select entire cells, rows, or columns. The format of the cells is also swapped, and the swapping process does not affect the formulas in the two panes and they still refer to the original cells. You can quickly swap cells or ranges in the same worksheet, different worksheets, or different workbooks. For example, you cannot swap two columns with one column.

The areas for the exchange must be identical in the same size.

With this tool, you can convert a single column of data into a table of data with five columns.Įxchange Ranks: Quickly swap ranges, columns, rows, and cells in your workbook. For example, you could have a single column of data that contains your customer’s information, and each customer consists of 5 rows of information (eg, name, gender, phone, email, and address). Transformation range: Quickly convert a vertical column into multi-column rows.
