Two ways to flip a table in Excel

In Microsoft Excel, there are a huge number of tools with which you can perform various tasks. There were difficulties if the user did not have the ability to turn the Excel spreadsheet 90 degrees in a few clicks. This is what this article will be about. We will look at two ways to best do this, so we recommend that you read the article to the end.

Transportation option

Before you talk about how to flip a table in Excel, it is worth saying that this operation is called in the "Transportation" program. In fact, the table is not flipped, only the data in the cells is flipped, although this can be considered one and the same.

The first way: a special insert

The first way to flip a table in Excel involves using a special insert. Let's look at an example of such a method.

, , . , :

1. . , .
2. . , , "". , CTRL+C.
3. , . , , .
4. , " ".
5. " ".
6. "", .
7. .

, , . , , , - .

, , . .

, Excel, , .

:

, Excel, , . , :

1. , . .
2. " ".
3. , "" "".
4. , . "", . "".
5. , CTRL+SHIFT+ENTER.

, , , , .

, Excel 90 , .