top of page

How to change a column to a row in Excel

Writer's picture: New HeightsNew Heights

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

ความคิดเห็น


ปิดการแสดงความคิดเห็น
bottom of page