#Where is transpose button in excel how to
#Where is transpose button in excel update

After selecting the cells, type the formula, i.e., =TRANSPOSE(A1:A5).To specify an array formula, you should select all the cells where the formula is required.The function that you will be entering must be typed as an array formula.The selected transpose range must be equal to the source range.The TRANSPOSE function returns a range of cells or array by converting the horizontal range of cells as a vertical range or vice versa.

SyntaxĪrray (required) - This parameter represents the data which you want to change from vertical to horizontal or vice-versa.

#Where is transpose button in excel update

Though users prefer the use of Transposed ranges as they are dynamic, i.e., if data in the original range changes, the TRANSPOSE() data will immediately update data in the new range. In Excel, the TRANSPOSE() function can be used with both cell ranges and arrays. In other words, when an array is transposed, the first row is flipped, and it becomes the first column of the new array similarly, the second row of the previous array becomes the second column of the new array, the third row will be converted as the third column, and so on. When you work with a horizontal range of cells, the TRANSPOSE() function changes the orientation to a vertical range.When you work with a vertical range of cells, the TRANSPOSE() function changes the orientation of vertical range to horizontal range.In simple terms, we can say this function 'flips' the placement of a given range of cells or Excel array: The Excel TRANSPOSE() function copies the data vertical range of cells to a horizontal range of cells, or vice versa (i.e., changes the orientation of horizontal range to vertical range range). If you don't want the duplication in your worksheet, you can type a customized formula instead of using the inbuilt TRANSPOSE function.įor instance, in the following reference image, the function =TRANSPOSE (A24:B44) takes the range of cells A24: B27 and organizes them horizontally (refer to the below screenshot). But this function formulates duplicated data. The other way round of switching and rotating your cells is using the Excel Transpose function. The hard way of achieving this is by copying, pasting the data to the required cells. To apply the formula, press CTRL+SHIFT+ENTER, as it as an array formula.Īs it can be seen that, this formula does not copy the formatting of the cells.While working with Excel, many times, you require switching or rotating cells in your worksheet. So, the formula becomes, =TRANSPOSE(A1:E6) Now, with all the selected cells, type the formula, =TRANSPOSE(, next specify the cells that need to be rotated, for this tutorial, they are A1:E6.

Remember, select the same number of cells as the original set of cells, but they should be rotated. We will be using the same data, for this method, you have to select blank cells, where you will use the TRANSPOSE function. This method does not copy the formatting of the cells of the original data.

This method is used to avoid duplicated data. This method makes duplicated data, to avoid this, TRANSPOSE function is used. The following image shows that the data is transposed, the rows and the columns are switched. Select all the data, press CTRL+C, to copy it, select the cell where the data should be pasted, press Right Mouse Button, and click Transpose under the Paste Options. The formatting of the new data is same as the original. With this method, rows and columns can easily be rearranged.

By using Copy, Paste and Transpose option.

By doing this, we can rotate rows and columns.

#Where is transpose button in excel how to

In this tutorial, we will learn how to use TRANSPOSE function and copy, paste & transpose to switch rows and columns.