Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-22-2020, 07:30 AM
DBenz DBenz is offline How does one copy paste to new workbook keeping formatting ? Windows 7 64bit How does one copy paste to new workbook keeping formatting ? Office 2010 32bit
Advanced Beginner
How does one copy paste to new workbook keeping formatting ?
 
Join Date: Dec 2014
Posts: 66
DBenz is on a distinguished road
Default How does one copy paste to new workbook keeping formatting ?

Hi, Excel2010.


I have a new empty workbook I want to copy a few sheets to for my accountant,

I select the cells starting at A1 and working down and across in the existing workbook on a sheet, go ctrl C, then in the new workbook select cell A1 and for paste I have no options showing of paste with format.
it shows three options under the paste icon in the toolbar,:-


paste
or paste Link
or Match destination formatting.



the latter keeps the rows 5mm tall but lacks all colours etc., and columns need widening out again.


Paste simply makes the normal narrow rows go massive height, a total mess.


Where is the ability to bring a sheet in and have it look like the source ?


My other option is to clone the entire workbook and spend hours deleting out all the sheets I dont want., but if they contain paste links then messes up data on the pages they feed.


At least with copy paste to a new workbook the formulae are nuked, just values remain which suits me.



DBenz
Reply With Quote
  #2  
Old 01-22-2020, 09:15 PM
GVaught GVaught 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
Novice
 
Join Date: Jan 2020
Location: Colorado
Posts: 12
GVaught is on a distinguished road
Default Copy formatting of a Worksheet

I'm not totally positive if this will work for you. Rather than selecting the cells you want, such as A1 to Z22 copy the entire page by clicking the corner triangle and then do your Ctrl + C or Copy of the worksheet. Then open a new Excel and complete the appropriate paste.

When I kept the Source formatting everything came over with formula's except the background my sheet contained. I believe you will need to copy multiple worksheets individually as a Group selection does not work, at least not for me.
Reply With Quote
  #3  
Old 01-25-2020, 12:33 PM
DBenz DBenz is offline How does one copy paste to new workbook keeping formatting ? Windows 7 64bit How does one copy paste to new workbook keeping formatting ? Office 2010 32bit
Advanced Beginner
How does one copy paste to new workbook keeping formatting ?
 
Join Date: Dec 2014
Posts: 66
DBenz is on a distinguished road
Default

Hi,
I had also tried the click top left corner where two grey bars meet which copies the entire sheet and had the exact same outcome of no means of bringing in the formatting.
There is a bring formatting in option within a workbook, but between workbooks it loses everything, now as this is a such a fundamental thing, I cant believe Msoft have denied it to us, but how is it done ?


DBenz
Reply With Quote
  #4  
Old 01-25-2020, 04:36 PM
GVaught GVaught 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
Novice
 
Join Date: Jan 2020
Location: Colorado
Posts: 12
GVaught is on a distinguished road
Default Excel 2010 Copying

I am using Excel 2019 now, however I just noticed you are using 2010. I vaguely remember sometimes on a copy of a workbook sometimes the Ctrl + C or copy from the menu would not capture everything into the clipboard and when you go to paste you only have three choices. Something appears to prevent you from getting the entire paste menu. I'm trying to remember how I solved that issue as I do remember it happening to me.

I just tried a paste special after I copied a worksheet from the corner and selected all except border and my formula's and conditional formatting came over into my new Excel workbook I opened. I also tried ALL the default and everything copied.

If you can get your paste button to give you this option, it might be an alternative.

Okay, I did a quick search on Excel 2010 and someone mentioned that Skype interferes with the copy and paste features. They uninstalled Skype and it worked for them. Had the same issue as you did.
Reply With Quote
  #5  
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: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
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

Thread Tools
Display Modes


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 03:04 AM.


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