Start With More Than One Worksheet

When you create a new workbook in Excel 2013 a single blank worksheet is added for you and named Sheet1.
This is different from previous versions of Excel where by default you were given three worksheets when you created a new workbook.

To change this default setting follow these steps…

Click the File tab
Select Options from the left pane.
In the General tab go to the section When creating new workbooks.
Next to Include this many sheets change to the number of blank worksheets you require when a new workbook is created.
Click the OK button.

The next time you create a Blank Workbook the default number of sheets will have changed.

Start With More Than One Worksheet

Be the first to comment

Leave a Reply