By EasyHow

How to flip a table

If you have a need for vertical location of the created table or horizontal placement vertical table, this operation can be done in several steps using a spreadsheet program Microsoft Office Excel.

You will need

Software Microsoft Office Excel.

Instruction

Open the program and upload that you created a document (Excel workbook).

Select the desired sheet in the workbook. Select the cells that are included in the tablethat you flip. To highlight the entire table, you'll need to clamp the cursor to the upper-left cell and pressing the mouse button, move to the bottom right cell of the table. Release the left mouse button.

After you create the allocation table, you need to copy it to the clipboard. This can be done in the following way:
- Ctrl + C;
- Ctrl +Ins;
- by pressing the right mouse button on the table – "Copy"item.

Right-click your mouse on the cell where you wish to place the inverted table. From the menu that appears, select "paste Special".

In the window "paste Special" check the box next to "Transpose". Click "OK" to confirm the changes to the table.

In the end, you get an inverted table.

Note

To return the changes, try the following methods:
- Ctrl + Z;
- click menu "edit" - select "Undo last action".

Useful advice

Before performing this operation it is recommended to change the cell format of the entire table, because in its turn, the data can be distorted. Select the entire table click the right mouse button on the selection – tab "Selection" - "Display" - check the box next to the value of "AUTOFIT".