![how to rotate columns in excel how to rotate columns in excel](https://i.ytimg.com/vi/grJ8BH1JuXY/maxresdefault.jpg)
Verify these formulas use absolute references-if they don’t, you can switch between relative, absolute, and mixed references before you rotate the data. If your data includes formulas, Excel automatically updates them to match the new placement. Īfter rotating the data successfully, you can delete the original table and the data in the new table will remain intact. Right-click over the top-left cell of where you want to paste the transposed table, then choose Transpose. The new table that you paste there will entirely overwrite any data / formatting that’s already there. Method 1: Transpose using Copy and Paste After then click into the empty cell where you want to transpose your Excel data. 1.Select the column data cells, and then click Kutools > Range > Transform Range, see screenshot. Our email addresses can be seen at the bottom of this page.Note: Ensure that you copy the data to do this, since using the Cut command or Ctrl+X won’t work.Ĭhoose a new location in the worksheet where you want to paste the transposed table, ensuring that there is plenty of room to paste your data. After installing Kutools for Excel, please do with following steps. If you have questions about this feature of Excel, or any other feature for that matter, please write to either of the co-founders os Internet4Classrooms.
![how to rotate columns in excel how to rotate columns in excel](https://www.techonthenet.com/excel/cells/images/rotate2016_002.png)
In the Select Data Source box, choose Switch Row/Column, as the thumbnail shows below. Now when you return to your spreadsheet, the text should be rotated. This value ranges from 90 degrees to -90 degrees. Then set the number of degrees that you wish to rotate the text.
![how to rotate columns in excel how to rotate columns in excel](https://key.technospot.net/blogs/img/2008/08/Transpose-Columns-to-Rows-Context-Menu-610x420.png)
When the Format Cells window appears, select the Alignment tab. Right-click in the white area of the chart and choose Select Data. Right-click and then select 'Format Cells' from the popup menu. If my intention was to change the headings on the X-axis, that must be accomplished differently. The chart below was produced from the original data and then the transposed data. Perhaps you are thinking that I might have transposed the data in order to change the look of a chart produced from the data. Select Excel Cell (Image instructions below) Click the Orientation drop down under the Alignment group of Home Tab Format Cells dialogue box Pop Out Then. This procedure is all about changing the look of the data. The data, as seen below, has been rearranged with a minimum of effort. Step Three (continued) - Click into the box beside Transpose and then click on the OK button. Step Three - Click on the down arrow under the Paste button on the Home tab, and select Paste Special In my example I clicked into cell A8 to select that cell as the place where I wanted the data to begin. Step Two - Select the cell where you want to move the data. Rotating Cells using Ribbon Tools First, we need to select a cell or a range of cells in which we want to apply the rotation of the cell. Step One - Copy the entire range of data, including the headers in row 1 and column 1. However, after looking at the data, I wished that I had organized it differently as below.
![how to rotate columns in excel how to rotate columns in excel](https://excelnumber.com/wp-content/uploads/Counterclowise-Text-Cell.png)
Now select anywhere you want to transpose.
#How to rotate columns in excel how to#
Excel has a much better option - transpose the data.īelow is my worksheet as originally set up. How to Transpose or Rotate Excel Cells (Row to Column and Vice-Versa) Select the cells and copy them. The old, slow way to accomplish that might involve clicking and dragging data or even starting over. Transposing Rows and Columns in MS Excel - 2007Īfter entering data in a worksheet, I decided to switch the location of the headers contained in row 1 and column 1.