If you’ve found this article helpful, please do post a comment below, and if you think others would find it useful, please share it using the sharing buttons below the article. In this article, we’ve learned how to change rows into columns and change columns into rows in Excel 2007, 2010, 2013 and probably 2016. Your original cells are still there – so highlight their columns, right-click with the mouse and choose Delete:Īnd here’s your spreadsheet, the opposite way around from how you started! Right-click with your mouse in an empty cell and then choose Paste Special and Transpose (a hint will appear when you hover over the button, but it’s the one on the bottom right)īehind all those dialogue boxes, Excel will show you what this is going to look like.Ĭlick on Transpose and your cells will appear, starting from the empty cell you clicked on: Don’t worry about it being in the middle of the spreadsheet, we will tidy that later. Now, and this is important, find a free, empty cell to paste into. Highlight the cells, right-click with the mouse, and select Copy: Here’s how to do it:įirst, copy all the cells you want to move: We want to turn this around so that everything runs along the top rather than down the side. Or, worse, someone might decide that for you and expect you know how to do it! How to change a column into a row or rotate a block of cells You might start off creating a header row then decide it should be a column, or create a spreadsheet then want to rotate it 90 degrees. Why would I want to swap a column for a row? In this article, I’m going to explain how to change a column into a row or change a row into a column in Excel 2007, 20 (I think this works in 2016 too but have not yet tested it).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |