Skip to playerSkip to main content
  • 7 weeks ago
Learn how to copy a sheet in Excel or move to another workbook. In this tip I will also demonstrate how do I copy an Excel spreadsheet into another without losing formatting. We will also look at how do I move from one sheet to another in the same workbook? Also, what is the shortcut to move sheet to another workbook in Excel and is it possible to move a worksheet to another open workbook but not to copy it there in Excel 2016? How do I copy a spreadsheet without formatting it? How do I save an Excel spreadsheet as a different file? Why can't I move a sheet to another workbook in Excel? How do I copy a sheet from one workbook to another without linking it? How to copy formula in Excel to another sheet without changing reference?

Copy Worksheet From One Workbook To Another Workbook
1) Open a new workbook.
2) Right-click the worksheet you want to copy.
3) Move or Copy...
4) "To book" set to your new workbook
5) Select "Create a copy".
6) OK

How to copy a sheet in Excel or move to another workbook,How do I copy an Excel spreadsheet into another without losing formatting?,How do I move from one sheet to another in the same workbook?,What is the shortcut to move sheet to another workbook in Excel?,Is it possible to move a worksheet to another open workbook but not to copy it there in Excel 2016?,How do I copy a spreadsheet without formatting it?,How do I save an Excel spreadsheet as a different file?,Why can't I move a sheet to another workbook in Excel?,How do I copy a sheet from one workbook to another without linking it?,How to copy formula in Excel to another sheet without changing reference?,
Transcript
00:00There is really a simple way to copy worksheets from one workbook to another.
00:04This method also keeps the cell formatting intact. Check this out.
00:08I have this sheet called number 208. I want to copy to a brand new sheet. I'm going to launch
00:14another workbook here. This is a brand new workbook with only one sheet called sheet 1.
00:20I'm going to copy 208 right across here. The way to do it will be, first of all, go to your
00:26original worksheet here. Right click on the sheet that you want to copy. Then you select move or copy
00:32from the context menu to book. You're going to select the book that you just opened here. It was called
00:38book 1 and then after that you're going to hit on create copy and click ok. Now if you look at your
00:45worksheet that you just opened a few minutes ago, you can see that
00:48the worksheet 208 has been copied over to the brand new workbook.
Be the first to comment
Add your comment

Recommended