If you want, you can copy the contents of an entire sheet from an Excel workbook in a few simple steps, then paste it into another sheet or program.

Fortunately, Excel 2007 enables you to select all pages and copy formatting to all of them. This method allows you save precious time and ensure formatting is consistent across all sheets.