![]() After that from the Copy ( see point 1 in image) drop-down select Transpose(T) ( see point 2 in image ).Select the cell where you will transpose.You can also do this by using Keyboard Shortcut. After we click Transpose(T) you will get your desired result.From the ribbon go to the Paste ( see point 1 in image) drop-down and select Transpose(T) ( see point 2 in image).Select the cell where we will transpose.From the Copy drop-down select Copy ( see point 3 in image).From the ribbon select Copy ( see point 2 in image).First, select the range we want to transpose.You can implement this Paste Special with both Ribbon Commands, Keyboard Shortcuts, and Mouse Shortcuts. The easiest way to transpose is by using Paste Special. 5 Methods for How to Transpose in Excel 1.
0 Comments
Leave a Reply. |