Change the number of worksheets in a new workbook

Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.

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 File tab.

  2. Under Excel, click Options.

  3. On the General 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.

  4. Click any other tab to return to your file.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×