This is the worksheet whose name tab appears in color and bolded when the sheet is inserted. If using these last two methods, however, note that Excel inserts the new worksheets to the left of the active worksheet. Alternatively, you could also press the keyboard shortcut of “Shift” + “F11” on your keyboard to automatically insert a new worksheet. Then select the “Insert Sheet” command from the drop-down menu. Alternatively, you can also click the “Insert” drop-down button in the “Cells” button group on the “Home” tab of the Ribbon. To insert a single new worksheet to the right of the currently selected worksheet, click the “New Sheet” button at the right end of the spreadsheet name tabs. Inserting and deleting worksheets in Excel is a critical skill to possess when working with Microsoft Excel workbooks.
In this tutorial, you will learn about inserting and deleting worksheets in Excel. Inserting and Deleting Worksheets in Excel: Overview