There’s a quick and easy way to move an entire Excel worksheet to a different workbook.
Side note: A workbook is what you’d typically think of as an Excel file. It can contain multiple work sheets. Worksheets are added, deleted and managed in the tabs at the bottom.
I’ve seen people copy entire worksheets using copy/paste. Which works fine, especially if you know the trick that clicking the box in the top left (right between A and 1) will highlight everything in the worksheet. However, this often means that you’ll need to reformat your column widths and row heights. A good solution to this problem is to copy the entire worksheet at once.
Step 1: Open both workbooks (the one with the worksheet you want to move and the one you want to move it to).
Step 2: Right-click on the tab for the worksheet you want to move. This will give you a menu. Select “Move or Copy”
Note: It’s possible to copy multiple worksheets at once, all you need to do is hold down Command (for Mac) and select multiple tabs BEFORE you right-click
Step 3a: Select the workbook you want to move your worksheet to
Step 3b: Select “Create a copy” (if you want to keep a copy in your current workbook)
Step 3c: Select ok.
Now your entire worksheet has been copied to another workbook.
thanks for your suggestions to move a copy a work book need to do this for a project at work ; I read some of your other writings very special. david
Thanks a lot… your tips really save my time..
Thanks, been doing it wrong. Great savings.
Glad this was helpful!
Mac: to click on tab use two fingers for a right click or hold down control key when you click on tab.
My entire workbook did not copy to new workbook only Sheet 1 did, did I miss something please?
This is how to copy one worksheet. If you want a copy of your entire workbook, you could save a new copy of the file.
there is no right click in Mac?
I set-up my MacBook to allow right clicks on the track pad. It’s been years since doing so but a quick google search explains a few different options