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.

Open your Excel spreadsheet first. However, it is recommended that you make a copy of this sheet as you will be making a few changes to the original spreadsheet.

Microsoft Excel 2010 provides a formula for calculating the average value from multiple worksheets in a workbook. Before you apply this formula, check that each worksheet is formatted the same way.