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