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
Hello,

How to copy data from one sheet in a row containing formulas to another sheet in a column but not in a row still have the same data with its formulas

Thanks,
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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:




Best regards,
Trowa

Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
0