filmov
tv
Excel Video: Paste Special Transpose
Показать описание
Use the 'Paste Special Transpose' option to switch rows to columns or columns to rows in Excel.
You can also use the TRANSPOSE function.
To transpose data, execute the following steps.
1. Select the range A2:D12.
2. Right click, and then click Copy.
3. Select cell A12.
4. Right click, and then click Paste Special.
5. Check Transpose.
6. Click OK.
Subscribe to my YouTube channel for more exciting Excel videos
You can also use the TRANSPOSE function.
To transpose data, execute the following steps.
1. Select the range A2:D12.
2. Right click, and then click Copy.
3. Select cell A12.
4. Right click, and then click Paste Special.
5. Check Transpose.
6. Click OK.
Subscribe to my YouTube channel for more exciting Excel videos
0:01:21
0:04:51
0:00:33
0:00:17
0:05:52
0:01:30
0:00:33
0:14:31
0:00:51
0:01:18
0:05:16
0:01:14
0:00:17
0:02:14
0:03:37
0:02:54
0:00:35
0:00:45
0:00:26
0:04:07
0:01:57
0:00:48
0:05:19
0:00:25