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:
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 lead directly to the provider. If a purchase is made through this, we receive a commission. There are no additional costs for 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
Warning:
Using Registry Editor or its tips incorrectly can cause serious system problems that may require you to reinstall your operating system. Tampering with the registry files and using the tips is at your own risk.