#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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. |
#5
|
||||
|
||||
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. |
|
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 |
Keeping track of the original file when you copy/paste | sidbisk | Excel | 2 | 09-01-2015 02:11 PM |
Keeping exact layout of source document when I copy and paste | mjbowen147 | Word | 1 | 11-17-2013 02:08 PM |