Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
I cannot see the Paste Special option f 'Match Destination formating' in Exce l 2010. I use this when subtotalling and then copying out data to another worksheet.