I need my workbook to have 10 worksheets by default

Asked By 10 points N/A Posted on -
qa-featured

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?

SHARE
Answered By 0 points N/A #200146

I need my workbook to have 10 worksheets by default

qa-featured

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

Related Questions