top of page
Writer's pictureNew Heights

How to change a column to a row in Excel

Updated: Apr 2, 2019

Moving the data from a column to a row in excel is quite easy to do. Just follow these steps.


1. Select all the column or group of cells in a column that you want to move to a row

2. Cut the cells using Control + x

3. Right click on the row where you want to paste the data - OR - select a cell and use the paste button on the top ribbon

4. From the fly out menu under the "paste" options, click the "transpose" icon.




































Want to learn more? Check out our excel training courses.

14 views0 comments

Comments


Commenting has been turned off.
bottom of page