How to add more sheets to an excell file?

Question

I m working in a excell file,which contains around 10 worksheets. this file is already connected with another excell file. I just want to insert 05 more sheets to the file which im working. I tired variuos methods but still fail to add any single work sheet. not via even macro.Pls help me.........

Answer 1

At the bottom where the tabs for the different worksheets are visible, right click on any of the tab. Select "Insert" and then "Worksheet" and it will add another worksheet.

Answer 2

Well, if the method mentioned above (right click on any sheet name at the bottom, and select "Insert") is failing, you are likely dealing with a protected workbook. Go to Tools, Protection, Unprotect Workbook. Hopefully there isn't a password lockin ya out.