Jan 29, · Detailed Solution. Download Solution PDF. Key Points. By default, any new workbook you create in Excel will contain one worksheet, called Sheet1. To change the default number of worksheets, navigate to Backstage view, click Options, then choose the desired number of worksheets to include in each new workbook. May 14, · "Share Workbook" from the list. Once you have identify it, click on "Add" (This will add the command in the new custom group". At last, click OK. P.S - Sorry for my bad English, the option was grayed out because the workbook was never "Shared" to be "Unshared". Hope the above will solve your problem.
Learn More