If you need to place a table you have created vertically or place a vertical table horizontally, this operation can be done in a few steps using the Microsoft Office Excel spreadsheet editor.
Necessary
Microsoft Office Excel software
Instructions
Step 1
Open the program and load the document you created (Excel workbook).
Step 2
Select the required sheet of the book. Select the cells included in the table that you will flip. To select the entire table, you need to hold down the upper left cell with the cursor and, without pressing the mouse button, move to the lower right cell of the table. Release the left mouse button.
Step 3
After creating a table selection, you need to copy it to the clipboard. This can be done as follows:
- keyboard shortcut Ctrl + C;
- keyboard shortcut Ctrl + Ins;
- by right-clicking on the table - item "Copy".
Step 4
Right-click on the cell where the flipped table will be located. From the menu that appears, select "Paste Special".
Step 5
In the "Paste Special" window that opens, check the box next to the "Transpose" item. Click the "OK" button to confirm the change to the table.
Step 6
As a result, you got an inverted table.
