Search This Blog

Monday, June 20, 2011

How to configure Excel to open only 1 sheet by default

Ever wondered why Excel opens 3 Sheets in a new Workbook and how to fix that to have only 1 sheet by default instead?

Here is a small setting officially provided by Microsoft to configure that.

  1. Start Microsoft Excel
  2. Ideally by default it should open a new workbook with 3 sheets
  3. Click on File tab, now select options from this tab
  4. In the resulting window with "General" section pre-selected, look for "When creating new workbooks" section
  5. 4th field in this section says "Include this many sheets" with default as "3"








  6. Change this to 1







Voila! Next time you start Microsoft Excel, it will create a new workbook with only 1 Sheet.

No comments:

Post a Comment