What you’ll learn to do: create a new workbook with more than one worksheet.

When you open a new Excel file, there is automatically a single worksheet. However, there are a number of reasons why you may want more than one worksheet in a single workbook. For example, consider the following ways multiple worksheets in a workbook can help with keeping data organized:

1. A workbook with monthly sales figure with each year on a different worksheet
2. A workbook with mailing lists for weekly flyers on one worksheet and coupon mailings on another
3. A workbook with inventory data with each month on a different worksheet

In any of these cases, or others, it is very easy to add more worksheets to an Excel workbook.

Contribute!

Improve this pageLearn More