4 Ways to Add a New Sheet in Excel

Often, users working in an Excel spreadsheet editor need to add a new worksheet to a spreadsheet document. Of course, you can create a new document, but it is advisable to use this option only in cases where there is no need to link a variety of information to each other. The program has several methods that allow you to add a sheet to a spreadsheet document. Let’s consider all the methods in more detail.

Excel spreadsheet button

This method is considered the simplest and most convenient to use. It is used by most of the users of the spreadsheet editor. The high prevalence of the method is explained by the fact that the algorithm for adding a new worksheet is very simple and understandable even for novice users.

You need to click LMB on a special element called “New Sheet”, located to the right of the existing worksheets at the bottom of the spreadsheet. The button itself looks like a small plus sign in a dark shade. The name of a new, newly created worksheet is assigned automatically. The title of the sheet can be edited.

Detailed instructions for editing the name are as follows:

1. Double-click LMB on the created worksheet.
2. Enter the name you want to give.
3. After carrying out all the manipulations, click on the “Enter” button located on the keyboard.

4. Ready! The name of the new worksheet has changed.

Using a special Excel context menu

The context menu allows you to implement the procedure for adding a new worksheet to a spreadsheet document in a few quick steps. Detailed instructions for adding looks like this:

1. We look at the bottom of the spreadsheet interface and find one of the available sheets of the document.
2. We click on it RMB.
3. A small context menu was displayed on the screen. We find an element called “Insert sheet” and click on it LMB.

4. Ready! We have added a new worksheet to the document.

You can see that this method, which allows you to add a sheet to a document using the context menu, is just as easy to use as the previously discussed method. The worksheet added by this method can be edited in the same way.

Pay attention!  Using the context menu, you can not only insert a new worksheet, but also delete existing ones.

The detailed instruction for deleting a worksheet is as follows:

1. We find one of the available sheets of the document.
2. Click on the sheet with the right mouse button.
3. A small context menu appeared on the screen. We find an element called “Delete”, click on it with the left mouse button.
4. Ready! We have removed the worksheet from the document.

Using the context menu, you can also rename, move, copy and protect the worksheet.

Adding a Worksheet Using the Tool Ribbon

You can add a new worksheet to an Excel spreadsheet document using a special multifunctional toolbar located at the top of the interface. Detailed instructions are as follows:

1. Initially, we move to the “Home” section. On the right side of the tool ribbon, we find an element called “Cells” and left-click on the arrow icon located next to it. A list of three buttons “Insert”, “Delete” and “Format” was revealed. Click the left mouse button on another arrow located near the “Insert” button.

2. Another small list of four items was revealed. We need the very last element called “Insert Sheet”. We click on it LMB.

3. Ready! We have implemented the procedure for adding a new worksheet to a spreadsheet document. It is worth noting that, as in the previously discussed methods, you can edit the name of the created worksheet, as well as delete it.

Important! If the spreadsheet window is expanded to its full size, then there is no need to look for the “Cells” element. In this case, the “Insert Sheet” button, located in the drop-down list of the “Insert” element, is located immediately in the section called “Home”.

Using Spreadsheet Hotkeys

The Excel spreadsheet has its own special hot keys, the use of which can significantly reduce the time it takes to find the necessary tools in the program menu.

To add a new worksheet to a spreadsheet document, you just need to press the key combination “Shift + F11” on the keyboard. After adding a new worksheet in this way, we will immediately find ourselves in its workspace. After a new worksheet is added to the book, its name can be edited in the above way.

Conclusion

The procedure for adding a new worksheet to an Excel document is a simple operation, which is one of the most common and frequently used by spreadsheet users. If the user does not know how to perform this procedure, then he will not be able to effectively and efficiently implement his work. The ability to add a new worksheet to a workbook is a basic skill that every user who wants to work quickly and correctly in a spreadsheet must have.