#1
|
|||
|
|||
How can I copy a worksheet and paste values to another new workbook ?
Hi,
Excel2010 I can select the corner of a sheet and go copy, then select the corner of a new sheet IN THE SAME WORKBOOK and go paste values. it all looks same as sheet it came from. try that for a new workbook and there is no paste value option ! I simple need to copy out a few sheets into a new workbook without formulae in them for my accountant to view values only, I also need to bring in the formatting. as it is I end up with cells totally different shapes and so on, a right mess ! Is there a better way to get my chosen sheets to occupy a new workbook with values and formatting as in source ? This is such a simple expected thing to do, I cant see why excel have made it so tricky if not impossible. My only other option is to make a copy of the workbook and work my way hundreds of sheets deleting them to slim it down to 5 or so, but in so doing that might ruin an values they feed to the sheets I need ! DBenz |
#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 |