SHAREPOINT - How to copy a tab to a different sheet?

Question

In sheet A, there are tabs 1, 2 & 3 for example.

I just want to copy TAB 2 to SHEET B.

Sheet A & Sheet B are not the same and are on different locations on SharePoint.

How do I do this?

Coming from Google Drive, where I would only have to right-click the tab 2, select COPY, and provide a LINK to the Sheet B. Not only does SharePoint not have the link option - but it seems COPY is missing too. This is such a simple task, please tell me there is a simple solution?

TY.

Answer 1

Dear Jokic,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

From your description copy a tab to a different sheet on SharePoint

Different as Google Drive, SharePoint doesn't support “copy columns”. However, if the 2 lists are on same SharePoint site, you can make the column a “site column”, so it can be applied to all lists on the site.

Kindly refer to this article to create a site column and apply it to different lists.

Create a column in a list or library - Microsoft Support

Besides, you can have more information about SharePoint columns from these articles.

What is a site column? | Microsoft Learn

List columns or Site columns Which one to choose? | Microsoft Learn

Your understanding and patience will be highly appreciated.

If there is any misunderstanding, please feel free to correct me.

Have a nice day!

Best regards,

Answer 2

Was this written by a bot?

I didn't mention anything about any columns, the articles you sent are of no use to me. Let's TRY AGAIN:

Answer 3

Dear Jokic,

Sorry for the misunderstanding before and thank you for the screenshots provided, from which we could understand your request better.

From our testing, we could not directly "copy" an excel tab to a different sheet from Excel Online. If you would like to perform the "copy" from online, you may need to press "Ctrl + A" and "Ctrl + C" to copy whole content, then paste to the other sheet via "Ctrl + V".

• To copy sheet, you need to open editing >> open in desktop.
• 
• You need to open both excel file on the desktop.
• 
• Click on the sheet icon on the bottom left click on move or copy. Select where you want to copy or move click okay.

Your understanding and patience will be highly appreciated.

If there is any misunderstanding, please feel free to correct me.

Have a nice day!

Best regards,

Answer 4

Thank you for your swift reply.

I have already tried Option 1 before and it is not very useful because the formatting doesn't transfer correctly.

Option 2 IS a solution, but I must notice it requires extra steps and it would be MUCH EASIER if we have this option in the Online editor as well.

I hope your development team considers evolving the product in this direction.

Thank you for your help!

Answer 5

Dear Jokic,

Good day! Thank you for your reply to Microsoft Community. We are happy to help you.

Personally I completely agree with you, this is indeed a good addition to the current features of SharePoint. Thank you for bring thing to our attention. We sincerely recommend you go to SharePointFeedback community to provide your feedback: SharePoint · Community (microsoft.com).This is the best platform to let related team hear from you and make the products and services better for you and others.

https://feedbackportal.microsoft.com/feedback

Your understanding and patience will be highly appreciated.

Have a nice day!

Best regards,