hasemfleet.blogg.se - Ms excel how many rows and columns in excel 2007

#Ms excel how many rows and columns in excel 2007 how to#

Once you have chosen the transpose option, the excel row data will be converted to the column as shown in the below result.Select the Transpose option in that, as shown below.We will get the paste special dialogue box.Once you copy the data, choose the new cell location.Click on the cell and copy the entire range of data as shown below.

#Ms excel how many rows and columns in excel 2007 how to#

We will see how to convert the column to row with the below steps. Suppose we need to convert the data column to rows in these cases TRANSPOSE function will be very useful to convert it, which saves time instead of entering the data. In this example, we will convert rows to the column in excel and see how to use transpose the employee salary data by following the below steps.Ĭonsider the above screenshot, which has id number, emp name, HRA, Allowance, and Special Allowance. For the end-user, if there is a huge data, this transpose will be very useful, and it saves a lot of time instead of typing it, and we can avoid duplication.

In this way, we can easily convert the given data from row to column and column to row in excel. In the above screenshot, we can see that rows have been changed to column and column has been changed to rows in excel.

Once we click on transpose, we will get the below output as follows.

Select the fourth option in paste special, which is called transpose, as shown in the below screenshot highlighted in yellow color.

Right, click on the new cell, and we will get the below option which is shown below.

Now select the new cells where exactly you need to have the data.

Copy the entire data by pressing the Ctrl+ C Key.

First, select the entire cells from A To G, which has data information.