Inserting worksheets in Microsoft Excel 2019

There are numerous methods to insert worksheets in Excel, as outlinednext, but the most efficient way is to click on the New sheet icon atthe bottom of the workbook, located to the right of any existingworksheets in the workbook, as illustrated in the followingscreenshot:

ms office 460
Note that this option is the only method that inserts a worksheetafter any existing worksheets.

Let’s look at the other methods to insert new worksheets, asfollows:

  1. Open the SSGProductSales.xlsx workbook.
  2. On the Home tab, locate the Cells group.
  3. Click on the drop-down arrow below the Insert icon.
  4. Click to select Insert Sheet.
  5. Depending on which sheet you were working on when you chose theInsert Sheet icon, the new sheet willalways appear before the sheet you were working on. In this case, thesheet inserts before the SSGProductssheet in the workbook, as this was the only sheet in the workbook. Thenew sheet is provided with a name according to the worksheet numbersequence. The last sheet in the workbook was SSGProducts, which is not understood byExcel as it is a custom worksheet name, so the new sheet is named Sheet1.

Or

  1. Right-click on a worksheet tab to access the shortcut menu.
  2. Click on the Insert… shortcut menuitem.
  3. From the Insert dialog box, chooseWorksheet.
  4. Click on OKand the newworksheet is inserted into the workbook.
The benefit of using this longer method to insert a worksheet is thatyou will have access to create different templates from the General, Spreadsheet Solutions, and 1033 tabs. You will also be able to accessonline templates from the icon at the bottom of the dialog box.

Leave a Comment