Directly copying data from RStudio to MS Excel

[clinical]

Dear Experts,
I am trying to copy data tables from RStudio to MS Excel. In Macbook, its working effortlessly. I can just press CMD+A, copy and directly paste onto excel sheet. All text, table and format are preserved. However, its not working on Windows 10 MS Office 365 Excel.
First, simple paste option doesn't paste anything. If I try to do paste special --> text/html, it pasts all data in a single long column. I don't remember what I did differently on Mac that it worked there. I am looking for your wise words on this issue please.
Thanks.

[jrkrideau]

Cross-posted to R-help list

FAQ: Is it OK if I cross-post?

Posting the same question both here and on other sites Posting the same question to multiple forums at the same time is often considered impolite. We don't completely ban such cross-posting, but we ask you to think hard before you do it and to follow some rules. Cross-post sparingly Rather than post the same thing here and elsewhere from the get-go, post in one place at a time. Let enough time go by (think days, not hours) before you take your question somewhere else. Sometimes people at another site may suggest you post here if your question doesn't fit within the scope of the other site. Always link to your other posts, and update everywhere with any solution…

I do not have Excel as I am on Linux but I suspect you would be better off just writing the data frame to Excel.

See something like https://tutorials.methodsconsultants.com/posts/reading-and-writing-excel-files-with-r-using-readxl-and-writexl/