Author > Creating questions and responses > Question type overview > Copying question and response text from other applications > Copying and pasting multiple rows from Microsoft Excel
 
Copying and pasting multiple rows from Microsoft Excel
When copying row information from Excel into an UNICOM Intelligence Author Description field, new categories will be created (instead of overwriting existing Description field information). When selecting a single text cell, the lines of text are pasted as a single piece of text. When the description cell of a category list is selected, multiple lines are pasted within the selected cell, resulting in multiple line description. This is done because it is not possible to determine whether you want multiple categories, or a multiple line description.
If you want to paste multiple categories you must select entire rows when copying from Excel. This is accomplished by clicking the row selectors to the left of the editable cells. Clicking the row selectors causes the entire row to become selected. After clicking the appropriate row selectors and copying the row information, pasting the multiple lines of text in UNICOM Intelligence Author will create a new category for each copied row.
Note When the copied selection exceeds the current Category Control row boundaries, new categories are added with IDs that are based on the first column of the copied cells.
See also
Copying question and response text from other applications