How to change default number of worksheet in Excel 2011 Mac

The number of worksheet associated with a new workbook in Excel 2011 for Mac is 1. And if your work requires adding a worksheet then you can click the plus sign to insert new sheet.

New Sheet Excel 2011

If you always require minimum of 3 worksheet in your new workbook then it is recommended to change the default number of worksheets for workbook to 3. You can change the number of sheets associated with a workbook using the options available as part of Preferences.

Click the Excel menu and select Preferences from the menu list.

Preferences Excel 2011

Click the General option under Authoring section in Preferences window.

Authoring Excel 2011

In the General Preferences, navigate to Sheet in new workbook and specify the number sheets as 3.

Sheets in new workbook Excel 2011

When a new workbook is launched it will open with number of sheets as 3.

In Category: Apple, Mac

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 0 Comments
No comments yet. Be the first.

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.