I need my workbook to have 10 worksheets by default

Asked By Corin Ronie 10 points N/A Posted on - 11/28/2014

I am into creating voluminous reports on Excel and hence would need up to 10 worksheets on an average in a workbook. However, Excel by default provides only 3 worksheets. I would like to know if this number can be changed  so that I get 10 worksheets by default in a new workbook.How can i I change this?

• Status: Open
• Question Views: 624
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Derick Harris 0 points N/A #200146

I need my workbook to have 10 worksheets by default

Hello Corin,

You need to follow below mentioned steps

1) Open Excel and click Files on Menu Bar

2) Click Options

3) After click options one screen will open, on that screen please observe the header " When creating new workbooks"

4) Please check the field "Include this many sheets" and on that field please put the value 10. Click Ok

5) Close Excel and again open it. You will see 10 tabs will come by default.

 

Regards,

Derick Harris

About Derick Harris

Questions
0

Answers
27

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 11/29/2014
• Question Category: MS Excel