How to Copy One Sheet of an Excel Workbook. The sheet of a Microsoft Excel workbook is a work space that contains a series of cells that contain your data. The data in the sheet can include ...

A complex Excel 2007 workbook could require multiple sheets. By default, Microsoft provides three sheets on each workbook, but you can add as many as you need.

However, no matter what version of Microsoft Excel you use, you get only one worksheet in one workbook. If you want to change the default number of worksheets in an Excel workbook, here is a trick.