Desktop User Guides > 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 are 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 in the selected cell, resulting in multiple line description. This is because it is not possible to determine whether you want multiple categories, or a multiple line description.
To paste multiple categories, you must select entire rows when copying from Excel: click the row selectors to the left of the editable cells. Pasting the multiple lines of text in UNICOM Intelligence Author creates a new category for each copied row.
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