Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-27-2020, 04:55 AM
p45cal's Avatar
p45cal p45cal is offline How does one copy paste to new workbook keeping formatting ? Windows 10 How does one copy paste to new workbook keeping formatting ? Office 2019
Expert
 
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default


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.
Reply With Quote
Reply



Similar Threads
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
How does one copy paste to new workbook keeping formatting ? Keeping track of the original file when you copy/paste sidbisk Excel 2 09-01-2015 02:11 PM
How does one copy paste to new workbook keeping formatting ? Keeping exact layout of source document when I copy and paste mjbowen147 Word 1 11-17-2013 02:08 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:23 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft