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