Contents
When working in Excel, it is often necessary to separate information. You can do this as on the same sheet, or add a new one. Of course, there is such an option as creating a new document, but it is applicable only if we do not need to link the data together.
There are several methods for adding a new sheet to an Excel workbook. Below we will separately consider each of them.
Content
New Sheet Button
By far, this is the easiest and most affordable method, which is likely to be used by most users of the program. It’s all about the maximum simplicity of the adding procedure – you just need to click on the special “New Sheet” button (in the form of a plus), which is located to the right of the existing sheets at the bottom of the program window.
The new sheet will be named automatically. To change it, you need to double-click on it with the left mouse button, write the desired name, and then press Enter.
You can add a new sheet in the book using the context menu. To do this, right-click on any of the sheets that already exist in the document. A menu will open, in which you should select the item “Insert Sheet”.
As you can see, the method is as simple as the one described above.
How to add a sheet through the program ribbon
Of course, the function of adding a new sheet can also be found among the tools located in the Excel ribbon.
- Go to the “Home” tab, click on the “Cells” tool, then on the small down arrow next to the “Insert” button.
- It is easy to guess what you need to choose from the list that appears – this is the “Insert sheet” item.
- That’s all, a new sheet has been added to the document
Note: in some cases, if the size of the program window is sufficiently stretched, you do not need to look for the “Cells” tool, because the “Insert” button is immediately displayed in the “Home” tab.
Using hotkeys
Like many other programs, Excel has , the use of which can reduce the time to look for common functions in the menu.
To add a new sheet in the workbook, just press the keyboard shortcut Shift + F11.
Conclusion
Adding a new sheet to Excel is the simplest function, which is perhaps one of the most popular and most used. In certain cases, without the ability to do this, it will be quite difficult or even impossible to do the job well. Therefore, this is one of the basic skills that everyone who plans to work effectively in the program should master.