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.

Suppose we have a table with a header in which data is entered. To flip it, you must do the following:

1. Select the table area in the program. To do this, hold the left mouse button in the upper left corner and drag the cursor to the lower right, then release the mouse button.
2. Place the selected area on the clipboard. To do this, right-click on the selected area, and select "Copy" from the menu. You can also speed up this process by pressing CTRL + C.
3. Now you need to select the area where the inverted table will be located. It is important to know that its beginning should not be in the area that already exists, so place the cursor in any empty cell.
4. Click on the selected RMB cell, and select "Paste Special" in the context menu.
5. From the submenu, select "Paste Special."
6. In the window that appears, check the box next to "Transport", do not touch other options.
7. Click OK.

After all the manipulations done, the table will become upside down in the place indicated. By the way, in some cases, it can shift due to lack of space in the cell, in this case, you just need to change their width or length.

As for the original table, you can either leave it or delete it. This will not make a change.

So readers have learned how to flip a table in Excel, but this is the first of two methods, so let's move on to the second.

Second way: special function

The second way to flip a table in Excel involves using a function that is designed to flip a table. To do this, you must:

1. Select an array of cells equal to the original table array. It is important to highlight outside the original table.
2. Click on the "Insert function" button.
3. In the window that appears, select the "TRANSPORT" function from the list and click "OK".
4. A window will open in which you need to specify the original table. To do this, click on the "Array" field, select the area in the program window. Then click "OK."
5. Now position the cursor at the end of the entered formula, press CTRL + SHIFT + ENTER.

As you can see, the table was inserted into the selected area upside down, but the formatting failed, which is not critical, it can easily be done again.

The second way, how to turn the table in Excel 90 degrees, will not cause difficulties for users.