To insert a new worksheet into a workbook, click the new sheet button located

Every workbook contains at least one worksheet by default. When working with a large amount of data, you can create multiple worksheets to help organize your workbook and make it easier to find content. You can also group worksheets to quickly add information to multiple worksheets at the same time.

Optional: Download our practice workbook.

Watch the video below to learn more about using multiple worksheets.

To insert a new worksheet:

  1. Locate and select the New sheet button near the bottom-right corner of the Excel window.
    To insert a new worksheet into a workbook, click the new sheet button located
  2. A new blank worksheet will appear.

    To insert a new worksheet into a workbook, click the new sheet button located

By default, any new workbook you create in Excel will contain one worksheet, called Sheet1. To change the default number of worksheets, navigate to Backstage view, click Options, then choose the desired number of worksheets to include in each new workbook.

To copy a worksheet:

If you need to duplicate the content of one worksheet to another, Excel allows you to copy an existing worksheet.

  1. Right-click the worksheet you want to copy, then select Move or Copy from the worksheet menu.
    To insert a new worksheet into a workbook, click the new sheet button located
  2. The Move or Copy dialog box will appear. Choose where the sheet will appear in the Before sheet: field. In our example, we'll choose (move to end) to place the worksheet to the right of the existing worksheet.
  3. Check the box next to Create a copy, then click OK.
    To insert a new worksheet into a workbook, click the new sheet button located
  4. The worksheet will be copied. It will have the same title as the original worksheet, as well as a version number. In our example, we copied the November worksheet, so our new worksheet is named November (2). All content from the November worksheet has also been copied to the new worksheet.
    To insert a new worksheet into a workbook, click the new sheet button located

You can also copy a worksheet to an entirely different workbook. You can select any workbook that is currently open from the To book: drop-down menu.

To rename a worksheet:

  1. Right-click the worksheet you want to rename, then select Rename from the worksheet menu.
    To insert a new worksheet into a workbook, click the new sheet button located
  2. Type the desired name for the worksheet.
  3. Click anywhere outside the worksheet tab, or press Enter on your keyboard. The worksheet will be renamed.
    To insert a new worksheet into a workbook, click the new sheet button located

To move a worksheet:

  1. Click and drag the worksheet you want to move until a small black arrow appears above the desired location.
    To insert a new worksheet into a workbook, click the new sheet button located
  2. Release the mouse. The worksheet will be moved.
    To insert a new worksheet into a workbook, click the new sheet button located

To change the worksheet tab color:

  1. Right-click the desired worksheet tab, and hover the mouse over Tab Color. The Color menu will appear.
  2. Select the desired color.
    To insert a new worksheet into a workbook, click the new sheet button located
  3. The worksheet tab color will be changed.
    To insert a new worksheet into a workbook, click the new sheet button located

The worksheet tab color is considerably less noticeable when the worksheet is selected. Select another worksheet to see how the color will appear when the worksheet is not selected.

To insert a new worksheet into a workbook, click the new sheet button located

To delete a worksheet:

  1. Right-click the worksheet you want to delete, then select Delete from the worksheet menu.
    To insert a new worksheet into a workbook, click the new sheet button located
  2. The worksheet will be deleted from your workbook.
    To insert a new worksheet into a workbook, click the new sheet button located

If you want to prevent specific worksheets from being edited or deleted, you can protect them by right-clicking the desired worksheet and selecting Protect Sheet from the worksheet menu.

Switching between worksheets

If you want to view a different worksheet, you can simply click the tab to switch to that worksheet. However, with larger workbooks this can sometimes become tedious, as it may require scrolling through all of the tabs to find the one you want. Instead, you can simply right-click the scroll arrows in the lower-left corner, as shown below.

To insert a new worksheet into a workbook, click the new sheet button located

A dialog box will appear with a list of all of the sheets in your workbook. You can then double-click the sheet you want to jump to.

To insert a new worksheet into a workbook, click the new sheet button located

Watch the video below to see this shortcut in action.

Grouping and ungrouping worksheets

You can work with each worksheet individually, or you can work with multiple worksheets at the same time. Worksheets can be combined together into a group. Any changes made to one worksheet in a group will be made to every worksheet in the group.

To group worksheets:

  1. Select the first worksheet you want to include in the worksheet group.
    To insert a new worksheet into a workbook, click the new sheet button located
  2. Press and hold the Ctrl key on your keyboard. Select the next worksheet you want in the group.
    To insert a new worksheet into a workbook, click the new sheet button located
  3. Continue to select worksheets until all of the worksheets you want to group are selected, then release the Ctrl key. The worksheets are now grouped.
    To insert a new worksheet into a workbook, click the new sheet button located

While worksheets are grouped, you can navigate to any worksheet within the group. Any changes made to one worksheet will appear on every worksheet in the group. However, if you select a worksheet that is not in the group, all of your worksheets will become ungrouped.

Which key is used to insert new worksheet in Excel?

Keyboard Shortcut to Insert a New Worksheet If you are a fan of keyboard shortcuts, this is probably the fastest way to insert a new worksheet in an already open workbook in excel. For this shortcut, hold the SHIFT key and then press the F11 key.

What is the shortcut key for insert new worksheet?

'Shift+F11' keys are used to insert worksheet in Microsoft Excel.

Where would you click to create a new worksheet quizlet?

click the (File) tab to display the backstage view..
select (New) on the left to display the new area on the backstage view (figure 1-1)..
Click (Blank Workbook) to create a new blank workbook..