And you will be able to see the transposed cells in the selected block of cells. This will apply the formula on the selected range.
After entering the formula, press the keys “Ctrl + Shift + Enter” this will enclose the formula into curly braces.Ĥ. The ‘range1’ argument signifies the range of cells that you want to transpose.ģ. Next, while keeping the block of cells selected enter the formula in the above formula bar. First of all select the range where you want to transpose your data.Ģ. Follow the below steps to use this method:ġ.
So, if after using this method your original data gets changed, then the change will be reflected in the transposed data as well. I have said this method better because in this way the results are dynamically generated from the original range unlike the above method. Transpose functionality of excel can be implemented in much better way using the transpose formula that excel supports. Method 2: To apply transpose function using formula: This will transpose your data and will paste it in the selected cell. In the ‘Paste Special’ window check the option that says ‘Transpose’ and hit the ‘OK’ button.ĥ. Now click the ‘Paste Special’ option, this will open the ‘Paste Special’ window.Ĥ. Next, Right Click on the area where you want to paste the transposed result.ģ. Select and copy the range of cells that you want to transpose.Ģ. Method 1: To apply transpose function using Paste Special option:Īpplying transpose using the paste special option is an easy way to perform transpose function in a much easier way. It is absurd if you are applying a transpose function on a single cell, as flipping a row into a cell doesn’t makes sense. Transpose is also an array function because it is applied on a block of cells. Array functions are enclosed by curly braces ‘’. Sometimes array functions are also called CSE functions, because these functions can only be entered by pressing “Ctrl + Shift + Enter” keys at the same time.
What are Array Functions and why transpose is an Array function?Īrray functions are different from normal functions as they deal with block of cells instead of a single cell. And today in this post I will be guiding you on how to use transpose functionality in excel. it can only be applied on a range of cells. And similarly transpose function in excel flips rows into columns and vice-versa. The term transpose literally means swapping rows and columns.
0 kommentar(er)
