Error of not being able to add sheets in Excel, how to fix?
You cannot insert a new worksheet while working with Excel? See now how to fix the error of not being able to add sheets in Excel shared by TipsMake to find a quick solution!
On forums, many people have complained about not being able to add new sheets to workbooks when using Excel. The familiar plus sign on the sheet tab is gray, even the Home-Insert-Insert trick is gray so new sheets cannot be added. Don't worry, TipsMake has found a way to fix the error of not being able to add sheets in Excel effectively. Apply now to fix this error!
Details on how to quickly fix the error of not being able to add sheets in Excel
How to insert additional sheets in Excel is certainly not unfamiliar to users. You can quickly click the + sign near the sheet you are working on below. Or click the Home tab > Insert > Insert Sheet and you're done. But in this case both methods cannot be done. Surely you will be extremely confused and not knowing what to do.
The cause of this situation may be because the working window is being protected. Therefore, you cannot add/delete/move/rename/copy sheets. There's also a possibility that due to an issue with the add-in, the adding new sheet feature isn't working. Here are the steps you need to take to fix the error.
1/ Unprotect workbook structure in Excel
Excel allows users to enable structure protection of all sheets in a spreadsheet. That means you cannot arrange or add new sheets to this spreadsheet. Therefore, you need to turn off the protection feature to be able to add new sheets to Excel.
- Step 1 : In the Excel window you are working and want to add a new sheet but cannot> The user clicks on the File tab > Select Info at the top.
- Step 2 : Click the Protect Workbook button > Select the Protect Workbook Structure option > When the small dialog box displays, enter the password you set to protect previously > Click OK to complete this process.
NOTE:
In case you do not remember the password protection and cannot insert a sheet in Excel, you can fix it by doing the following:
- Step 1 : Install Excel Password Recovery program on your computer > Open this software and upload Excel with worksheet protection turned on but don't know the password.
- Step 2 : Tick Remove Worksheet & Workbook Password > Click Next .
- Step 3 : Wait a moment and then click Go to folder > So the Excel file has been unlocked and you can freely edit and add new sheets.
2/ Run Excel in safe mode
As the admin shared, the problem may originate from Excel add-ins. Therefore, press Windows + R > Enter the command excel /safe > Press Enter > After opening Excel in safe mode, try checking to see if you can add a new worksheet as usual.
If the problem cannot be resolved with the above tips, users should try clearing Office's hidden cache or repairing Office installation. These are quite effective solutions if the cause is because the Excel version is having problems and cannot add new sheets.
Although the error of not being able to add sheets in Excel does not have too many solutions, in fact, many people have solved the problem right from method 1. Therefore, TipsMake hopes that you can also fix the error quickly.
You should read it
- Tricks using Google Sheets should not be ignored
- 5 reasons you should give up Excel and start using Google Sheets
- How to convert Excel file to Google Sheets
- How to print multiple sheets in Excel
- How to print multiple sheets at once in Excel spreadsheets
- MS Excel - Lesson 4: Working with lines, columns, sheets
- 30+ useful Google Sheets functions
- How to compare data on 2 different sheets in Excel file
May be interested
- How to copy and move Sheets in Excel simply and easilycopying and moving sheets in excel is an important operation to help manage data effectively. this article will guide you through quick, simple ways to do it, suitable for many versions of excel.
- Google Sheets automatically creates tables with just 1 click, making Excel converters excitedgoogle has finally added automatic one-click table creation in sheets, something excel has had for years.
- 30+ useful Google Sheets functionsgoogle sheets is a great alternative to microsoft excel. it's packed with useful features, including a wide range of functions that cover most of those available on excel and more.
- What is ### error in Excel? how to fix ### error in Excel### in excel is an error that excel frequently encounters and appears in many different cases when we enter data in excel, functions in excel, enter formulas in excel or when displaying results.
- How to compare data on 2 different sheets in Excel fileto compare data on 2 different sheets but in the same excel file, we have many different methods such as using vlookup or using the countif function and combining with conditional formating to create different comparison effects. or no difference in data in two different sheets.
- How to Unprotect Excel Sheettipsmake today will show you how to unprotect worksheets in microsoft excel workbooks on windows or macos. if the sheet is password protected and you don't know it, you can use google sheets or a vba script (on earlier versions of excel) to remove the protection.
- List of common shortcuts for Google Sheets on Chrome OS (Part 3)google sheets consists of worksheets, each sheet consists of multiple cells created by rows and columns, the toolbar supports basic tools such as formatting sheets, cells, text, inserting charts, images, ... .
- How to hide and hide sheets in Excel and show them againhide sheets in excel makes excel spreadsheets easier to see, and more to work on content on a sheet.
- How to Add a New Tab in Excelyou can add tabs in excel, called 'worksheets,' to keep your data separate but easy to access and reference. excel starts you with one sheet (three if you're using 2007), but you can add as many additional sheets as you'd like. open your...
- List of common shortcuts for Google Sheets on Mac (Part 2)using keyboard shortcuts to import data into a table makes it easy to understand how google sheets uses it to help you work faster and more efficiently. in the next section, network administrator will introduce you to the list of common google sheets shortcuts on mac.