![]() |
|
#2
|
|||
|
|||
|
1. Right-click on the tab (left below) that you want to copy and choose: Move or Copy….
2. Select (below): Create a copy. 3. Above, under "To book", click on the arrow and choose: New book. 4. Click Ok. A new workbook opens with the copied sheet on Sheet1; give the new workbook a name and save it. When you press and hold the Ctrl-button, you can select and copy more than 1 sheet at a time to the same new workbook. |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Summing data from multiple worksheets in a workbook and placing into another worksheet
|
safrac | Excel | 17 | 10-04-2022 12:21 PM |
| Looking to copy select cells in table using dropdown list to paste to new table in another worksheet | CaptainRetired | Excel Programming | 18 | 01-04-2018 07:22 PM |
| How do I populate Worksheets using information entirely from another Worksheet in the same Workbook? | BrieDanielle | Excel | 1 | 06-18-2016 10:50 AM |
Looping through rows and copy cell values to another worksheet
|
get4hari | Excel Programming | 1 | 10-02-2015 04:51 PM |
| Can you copy & paste cells across worksheets and preserve reference to worksheet? | New Daddy | Excel | 2 | 11-27-2013 07:19 AM |