How to Only Have One Worksheet by Default in Excel 2013

Most workbooks in Microsoft Excel 2013 will include 3 worksheets by default. Using multiple worksheets within an Excel workbook is helpful when you have a lot of related data that does not belong in the same spreadsheet, but a large percentage of Excel users will rarely ever use more than one sheet within their workbooks.

Fortunately you can adjust the number of worksheets that are in a default Excel 2013 workbook, and that number can be changed to one, if you are so inclined. Our guide below will show you where the default worksheet setting is located so that you can change it.

 

Set Default Number of Worksheets to One In Excel 2013

The steps in this article will show you how to change the default number of worksheets in new Excel 2013 workbooks to 1. This will not affect the number of worksheets in existing workbooks, and you will still be able to delete worksheets or add them as needed.

 

  1. Open Excel 2013.
  2.  

  3. Click the File tab at the top-left corner of the window.
  4. click the file tab

     

     

  5. Click the Options button at the bottom of the column on the left side of the window.
  6. click options in the left column

     

     

  7. Confirm that the General tab is selected in the left column of the Excel Options window, then change the number in the field to the right of Include this many sheets to “1”. You can then click the OK button at the bottom of the window to save your changes.

change default worksheets to one in excel 2013

 

 

The next new workbook that you create in Excel 2013 will now have just one worksheet tab. If you wish to add more tabs to a workbook, but do not want to change the default setting, you can simply click the + button at the bottom of the window, to the right of the existing worksheet tabs.

add new sheet in excel 2013

 

 

If you are having trouble identifying the different worksheets in an Excel workbook, then it can be helpful to give them more helpful names. Learn how to edit the name of a worksheet in Excel 2013 with something more descriptive than the default naming convention.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy

Newest Guides