Home

Trying to add a new workbook into my Excel Spreadsheet. The "+" is not available.

%3CLINGO-SUB%20id%3D%22lingo-sub-796018%22%20slang%3D%22en-US%22%3ETrying%20to%20add%20a%20new%20workbook%20into%20my%20Excel%20Spreadsheet.%20The%20%22%2B%22%20is%20not%20available.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-796018%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20add%20a%20new%20tab%20(Workbook)%20to%20my%20spreadsheet%2C%20but%20the%20%2B%20sign%20is%20not%20available%20to%20click%20on.%26nbsp%3B%20Does%20anyone%20know%20how%20to%20work%20around%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-796018%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-796056%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20add%20a%20new%20workbook%20into%20my%20Excel%20Spreadsheet.%20The%20%22%2B%22%20is%20not%20available.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-796056%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F389467%22%20target%3D%22_blank%22%3E%40BethT%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20send%20a%20print%20screen%20of%20the%20bottom%20of%20your%20workbook%3F%20I%20am%20curious%20what%20you%20see.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20meantime%2C%20you%20may%20press%20Shift%2BF11%20or%20Alt%2BShift%2BF1%20to%20insert%20a%20new%20worksheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-796175%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20add%20a%20new%20workbook%20into%20my%20Excel%20Spreadsheet.%20The%20%22%2B%22%20is%20not%20available.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-796175%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F126275i96F04BD58C212DD9%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F126277i58921431493DAEA0%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_1.png%22%20title%3D%22clipboard_image_1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-796178%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20add%20a%20new%20workbook%20into%20my%20Excel%20Spreadsheet.%20The%20%22%2B%22%20is%20not%20available.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-796178%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3BI%20tried%20the%202%20options%20you%20stated%20above%20but%20it%20still%20isn't%20adding%20a%20new%20workbook%20unfortunately.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-796200%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20add%20a%20new%20workbook%20into%20my%20Excel%20Spreadsheet.%20The%20%22%2B%22%20is%20not%20available.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-796200%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F389467%22%20target%3D%22_blank%22%3E%40BethT%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3EPerhaps%20you%20have%20protected%20workbook%20structure%2C%20you%20may%20check%20in%20File-%26gt%3BInfo%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-797837%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20add%20a%20new%20workbook%20into%20my%20Excel%20Spreadsheet.%20The%20%22%2B%22%20is%20not%20available.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-797837%22%20slang%3D%22en-US%22%3ESergei%20is%20correct%2C%20the%20workbook%20is%20protected%2C%20which%20disables%20the%20addition%20of%20worksheets.%20(%22Tabs%22%20are%20%22worksheets%22%2C%20whereas%20the%20entire%20file%20is%20a%20%22workbook%22.)%3C%2FLINGO-BODY%3E
BethT
New Contributor

I'm trying to add a new tab (Workbook) to my spreadsheet, but the + sign is not available to click on.  Does anyone know how to work around this?

5 Replies

Hello @BethT,

 

Can you send a print screen of the bottom of your workbook? I am curious what you see.

 

In the meantime, you may press Shift+F11 or Alt+Shift+F1 to insert a new worksheet.

@PReagan I tried the 2 options you stated above but it still isn't adding a new workbook unfortunately.

@BethT ,

Perhaps you have protected workbook structure, you may check in File->Info

Sergei is correct, the workbook is protected, which disables the addition of worksheets. ("Tabs" are "worksheets", whereas the entire file is a "workbook".)
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies