Special Paste - Transposition
Page visited 8385 times
|
1. If you wish to change the orientation of your table, Special Paste will be very useful.
|
|
|
|
|
|
|
|
|
2. In this example, you will change the orientation of the range A1:F2
|
|
|
|
|
|
|
|
3. Select the appropriate range
|
|
|
|
|
|
|
|
|
4. Activate the menu bar Edit/Special Paste and check the check box ‘Transpose'. Now your table is presented vertically
|
|
|
|
|
|
|
|
|
5.
|
|
|
|
|
|
|
|
