DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
To paste copied data from horizontal to vertical, which option would you use from Paste Special?
|
|
Values
|
|
|
Formulas
|
|
|
Transpose
|
|
|
Formatting Only
|
Explanation:
Detailed explanation-1: -Select the first cell where you want to paste the data, and on the Home tab, click the arrow next to Paste, and then click Transpose.
Detailed explanation-2: -Select the first cell of destination column, right click and select the Transpose (T) in the Paste Options section of the right-clicking menu. See below screenshot: And now the row is copied horizontally and pasted as one column vertically.
Detailed explanation-3: -Here’s how you can transpose cell content: Copy the cell range. Select the empty cells where you want to paste the transposed data. On the Home tab, click the Paste icon, and select Paste Transpose.
There is 1 question to complete.