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

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.