|Connect us with


What is Transpose in Excel?

Transpose is a function that is used to convert a vertical range of cells to horizontal range or horizontal to Vertical range in Excel. The TRANSPOSE function must be entered as a range that has the same number of rows and columns, respectively, as the source has columns and rows. Use TRANSPOSE to shift the vertical and horizontal orientation of an array or range on a worksheet. this function applies only for the range of cells it will not apply for a single cell. below we provided a downloadable sample sheet & video for your understanding.

Syntax:-TRANSPOSE(array)

How to Use Transpose in Excel?

Method 1:

  • Select Cell Range that you want to Transpose.
  • And copy the Select Cell Range that you want to Transpose.

  • How to Use Transpose in Excel?

  • Go to the Area where you want to Transpose selected values and Right-click there and Check the Transpose CheckBox.

  • How to Use Transpose in Excel?

  • Click on OK.

  • How to Use Transpose in Excel?

Method 2:

  • Select Cell Range that you want to Transpose.
  • Highlight blank cells where you want to get results.
  • Type a formula TRANSPOSE and select range of cells(A1: A7) and Don't Press Enter.

  • How to Use Transpose in Excel?

  • Here is the Important Point. Press CTRL+SHIFT+ENTER.

  • How to Use Transpose in Excel?

  • Using this method if you change the Cell values Also Transpose will Work Accordingly.
After watching the video you can download below sample sheet. and it helps you to do practice more. please subscribe for more videos on our youtube channel.if you like our tutorial please share it on Facebook and Youtube below.

To Get FREE Excel Shortcut Keys
       



Previous

Next



YOUR COMMENTS ARE MOST IMPORTANT TO US:

0 Comments



Why basictutorials.in ?

● To Learn Tutorials in a Simple Way.

● To Learn Excel Basics With Downloadable Samples.

● To Learn HTML With Sample Website Code.

● To Learn PowerPoint Presentations.

● To Learn MS Word for Offical use.