Change the default number of worksheets


Here is the quickest way to always get your Excel workbooks to open with a default number of sheets to be as many (or as few!) as you want.
For Excel 2007

  1. Office Button
  2. Excel Options
  3. Change the ‘Include This Many Sheets’ to what you want- in my case it’s always 1.
  4. Click Ok to save the default

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>