Ask Question
28 October, 12:51

When pasting a range cells click the paste options button and then select the transpose option to

+1
Answers (1)
  1. 28 October, 15:29
    0
    Switch rows to column and vice versa

    Explanation:

    Transpose "pasting option" is used to switch positions of cells from rows to column or from columns to rows depending on the current position of the cells being highlighted.

    This can be done in two ways

    1. Follow the steps as it is in the question above

    2. Use the excel transpose inbuilt function.

    Either of these two ways will give the desired result.

    But is should be noted that, the transposing cells will not copy the formats (bold, italics, underline, etc.) of the selected range of cells; buy rather only the cell values will be copied.

    Lastly, when making use of transpose, cells at the first rows will maintain the first column, those at the second row will maintain the second column, those at the third row will maintain the third column till it gets to the last row and column.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question ✅ “When pasting a range cells click the paste options button and then select the transpose option to ...” in 📘 Computers and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers