Excel - Convert a row into a column and vice-versa

It may happens that you need to convert a row into a column or vice-versa, under Excel. That is: transfering all the cells from an horizontal display to a vertical one or otherwise. Here's a small trick:

  • Select the targeted cells.
  • Do a CTRL+C to copy them.
  • Move to the first cell of your new row/column (Note that this cell must be outside the copy area).
  • Right click> Paste Special.
  • Check the "Transpose" option and click on OK.

Here's the result:

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
This document, titled « Excel - Convert a row into a column and vice-versa », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).