Excel
Closed
Popo
-
Feb 4, 2015 at 10:49 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 5, 2015 at 11:22 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 5, 2015 at 11:22 AM
Related:
- Excel
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Gif in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Excel marksheet - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Feb 5, 2015 at 11:22 AM
Feb 5, 2015 at 11:22 AM
Hi Popo,
After copying your data, right-click the destination cell and choose Paste Special. Here you will find the option to both keep formula's and to transpose (row to column and vice versa) your data.
Even thought the pics below are in Dutch, they still may aid you in finding the right options:![](https://img-16.ccm2.net/5NhJtV31M9Bf1jnD23lEp9njax4=/811ba6839f814679994fe59aa0d1aeb6/ccm-ugc/uxIM0zkufM0YadA2wjz6EQBjWQq-popo1-s-.png)
![](https://img-16.ccm2.net/IrGZB3jy6fmgcdHTv0k8jg7AxL0=/440x/5bed9023df07451a96c2e0d5f50837cc/ccm-ugc/ruf8zgg8CD3VBrrKu01jQ2thZp8FDP-popo2.png)
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
After copying your data, right-click the destination cell and choose Paste Special. Here you will find the option to both keep formula's and to transpose (row to column and vice versa) your data.
Even thought the pics below are in Dutch, they still may aid you in finding the right options:
![](https://img-16.ccm2.net/5NhJtV31M9Bf1jnD23lEp9njax4=/811ba6839f814679994fe59aa0d1aeb6/ccm-ugc/uxIM0zkufM0YadA2wjz6EQBjWQq-popo1-s-.png)
![](https://img-16.ccm2.net/IrGZB3jy6fmgcdHTv0k8jg7AxL0=/440x/5bed9023df07451a96c2e0d5f50837cc/ccm-ugc/ruf8zgg8CD3VBrrKu01jQ2thZp8FDP-popo2.png)
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.