Rotate Excel table (transpose)
An Excel table has the following structure and should be rotated:
Table 1
| Column A. | Column B |
| Bernd | 01.01.1980 |
| French | 02.02.1970 |
The magic word is "Transpose"and rotates copied tables.
To make the table look like Excel table 2, proceed as follows:
Advertising
Table 2
| Column A. | Column B |
| Bernd | French |
| 01.01.1980 | 02.02.1970 |
Mark and copy the cells of the table. Select cells> right mouse button> insert content, set the option "Transpose" in the following window and confirm with OK.
Questions about Office or especially Excel click here
more interesting Excel tips:
- Delete duplicate entries in Excel 2007
- Include Excel graphic in the header
- Enter numbers as text / display leading zeros
| Transparency: | This article may contain affiliate links. These will take you directly to the provider. If you make a purchase through one of these links, we will receive a commission at no extra cost to you. These links help us to refinance the operation of win-tipps-tweaks.de. |
This tip comes from www.win-tipps-tweaks.de
© Copyright Michael Hille
