Want to become an expert in VBA? So this is the right place for you. This blog mainly focus on teaching how to apply Visual Basic for Microsoft Excel. So improve the functionality of your excel workbooks with the aid of this blog. Also ask any questions you have regarding MS Excel and applying VBA. We are happy to assist you.

How To Switch Rows And Columns In Excel

Excel stores your data using a grid of cells. Rows are named with numbers and columns are named with letters. Sometimes you may want to transpose your data. For example, assume you have a worksheet like this.

Excel worksheet before transpose

Then sometimes you would want to switch rows and columns like this.

Excel sheet after switching rows and columns

There are few different ways to do this. In this post I will show you how to do this using the Paste Special method.

First select the range of data you want to transpose. Remember to include row and column labels if there are any.

Select the data range

Then copy that data. You can press Ctrl + C from the keyboard or you can select “Copy” from the Home tab.

Select Copy from the Home tab

Or else you can right click on one of selected cells. Then select “Copy” from the shortcut menu.

Select Copy from shortcut menu

You can use one of the above three methods to copy the data. Next you need to use the “Paste Special” method. Select the first cell where you want to paste your data. Then click on the dropdown button next to “Paste” in the “Home” tab.

Click the dropdown button next to Paste

Then Excel will show you various paste options available. Select the “Transpose” option from the list.

Select Transpose from paste options

Or else you can right click on the first cell where you want to paste the data. Then select the “Transpose” option from the shortcut menu.

Select transpose from the shortcut menu

And this option is also available under the Paste special.

Paste special options

Also see:

How to transpose columns and rows using VBA

Contact Form


Email *

Message *