How To Add a New Worksheet into a Microsoft Excel Workbook?

As described in another video of mine, I mentioned that when we open Microsoft Excel, we are opening a Workbook. A Workbook that contains one or more different Worksheets. A Worksheet is a collection of Cells organized in Rows and Columns. It is where we enter the data. We can add as many Worksheets as we want in a Workbook but only one of them at a time can be activated. Worksheets are also referred as Spreadsheets. Do not let it confuse you. The procedure for adding a Worksheet can be done in a couple of ways. Just select the one that is more convenient for you.

If You Want To Learn To Add a New Worksheet into a Microsoft Excel Workbook, read the post that follows.

 

In the next image, I have opened a Microsoft Excel Workbook that already has Four (4) Worksheets. At then end of the Fourth Worksheet at the right there is a Plus (+) Symbol as shown in the image below. We just press the Plus (+) Symbol and a New Blank Worksheet will be created and located at the End.

Say that we want to Insert a Worksheet between the First and the Second Worksheet. We activate the Second Worksheet by clicking on it with our mouse and then we do a right click on it. The shortcut menu appears as shown, where at the top of the shortcut menu we select the command Insert.

Once the Insert command is selected from the shortcut menu, the Insert dialog box appears as shown in the image below. Under the tab General of the Insert dialog box, the first option to select is a Worksheet. In the Insert dialog box, there are other options to select from which some are: Chart, MS Excel 4.0 Macro, International Macro Sheet and etc. Once the Worksheet option is selected, we just press the Ok button located at the bottom right of the Insert dialog box.

In the image below, we can see that the New Worksheet has been inserted between the two Sheets that I mentioned above. The New Sheets name is Sheet1.

Finally, the third way that we can Insert a New Worksheet is the following. Say again that we want to Insert a New Worksheet between the second and third Worksheet. We must select the third Worksheet, because the New Worksheet will be inserted at the left of the activated Worksheet and then from the Home tab of the Ribbon we locate the area named Cells.

From the area of the ribbon named Cells, we select the command Insert and from the drop-down menu that appears we select the command Insert Sheet as shown in the image below. Once again, the New Worksheet will be inserted at the left of the activated Worksheet.

FYI: An Excel Workbook can contain 255 Worksheets.

Go ahead can check out the video describing How To Add a New Worksheet into a Microsoft Excel Workbook?

and …

To Find Out More About Microsoft Office Applications You Can Subscribe To My YouTube Channel!!!