Excel

[Closed]
Report
-
Posts
2805
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 14, 2021
-
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,

1 reply

Posts
2805
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 14, 2021
482
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.