Replace Excel matrix
Excel is often used to create a table of summation, average, and comparison values of data data. If you are in a hurry at this time, you may be wondering whether the position of the table of contents of each item should be in rows or columns, but it is better to write the concept as you think. This is because you can edit when the viewing method is different. Now, if you have created an Excel table, let's look at the form and try how to change Excel rows.
Replace Excel matrix
The table data created as follows is designated as a block and copied. The shortcut key for copying is Ctrl + C. Of course, this is a basic function that can be easily found in the home tab of the top menu.
Replace Excel matrix
Generally, after copying, you paste it, but you usually use Ctrl + V keys where you want to paste. However, in order to use the Excel row change function, please use the right mouse button. Below are the option menus that appear when you click the right mouse button at the location to paste. It is an icon and menu item that you can use the Excel row column replacement function as indicated by red squares. You can select the icon, but for a more precise name and method, select the'Paste Special' option.
Replace Excel matrix
If you select Paste Special, the following are the options for the names of the icons you just viewed. The name is also provided, so you will know exactly what order to give. Check the'Row/Column Change' item at the bottom of the popped up option window and select the OK button.
This is the result of using the Excel column change function. It is a good function to use when necessary by judging which document to change when creating.