Most of the time we'll be working on some tables in Microsoft Excel 2007, but there's a problem with the totals: There are vertical rows in the tables, some are horizontal. Summing up together is bound to be arranged in the same way to discharge the results, and it seems that you must also convert the rows and columns of Excel 2007 data.
How do I do the row and column conversions of Excel 2007 data? Is it hard to cut and paste one by one? Of course, Excel Software has already provided this functionality for us. The operation is as follows:
The first step, "select" to convert the area of the data, and then click "Copy";
In the second step, move the pointer to the appropriate cell, right-click, and select "Paste selectively" in the right-click menu.
The third step, in the pop-up "Paste selective" dialog box, with the left mouse button in the lower right corner of the "transpose" selected, and finally click "OK" can be.
In this way, the final result appears in the pasted area, the row is converted to a column, or the column is converted to a row.