how to copy and paste an excel sheet with formatting?
['Select the cell or cells whose format you wish to copy.', 'Press Ctrl+C or press Ctrl+Insert. ... ', 'Select the cell or cell range into which you want the formats pasted.', 'Choose Paste Special from the Edit menu. ... ', 'Choose the Formats radio button.', 'Click on OK.']