Change the number of worksheets in a new workbook

By default, Microsoft Office Excel provides three worksheets in a workbook, but you can change the number of worksheets that appear by default in a new workbook.

  1. Click the Microsoft Office Button Office button image , and then click Excel Options.

  2. On the Popular tab, under When creating new workbooks, in the Include this many sheets box, enter the number of sheets that you want to include by default when you create a new workbook.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×