Monday, May 25, 2009

Changing the Default Number of Sheets in Excel

[For Excel 2000/2002/2003]

To change the default number of sheets in a new Excel workbook, go to Tools > Options > General tab and change "Sheets in new workbook". The default in Excel 2003 is 3 sheets, but I find that extremely annoying and instead of always deleting the other 2 sheets, I just set the default to 1.

3 comments :

Alan Murray said...

This can be definitely be useful to bare in mind. I was training at a location just the other day and on opening Excel saw 1o worksheets.

You never know what your going to get when training on site.

Dwijayas said...

I better leave it alone because I think I could use it for another purpose.

Cater said...

This is very help who use MS 0ffice 2000 / 03. Thankx for providing such article.