N/APosted 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?
I need my workbook to have 10 worksheets by default
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.