![]() |
|
#1
|
||||
|
||||
![]() Try right-clicking the tab of the sheet you want to copy, choose Move or Copy…, then in the To book: field dropdown choose your destination workbook, choose where you want it to go relative the existing sheets in the destination workbook in the Before sheet: field, tick the Create a copy checkbox, click OK, then you can delete stuff you don't want in the copied sheet. Before this operation, you can select multiple sheets (using the Ctrl key on the keyboard if they're not all next to each other, using the Shift key if they are, or a combination) to save the repetitive work. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I copy a workbook to another workbook and keep the formatting within the new workbook | excelforsue | Excel | 3 | 09-15-2020 03:37 AM |
How can I copy a worksheet and paste values to another new workbook ? | DBenz | Excel | 1 | 01-26-2019 07:03 AM |
Copy Sheets to New Workbook BUT Keeping Format | @MacroZinck | Excel Programming | 0 | 02-01-2018 08:04 AM |
![]() |
sidbisk | Excel | 2 | 09-01-2015 02:11 PM |
![]() |
mjbowen147 | Word | 1 | 11-17-2013 02:08 PM |