Inserting and Deleting Worksheets

If you haven’t changed Excel from the way it was installed, any workbooks you create will contain three worksheets. Three worksheets are plenty of room if you’re working at home and are perhaps more than you’ll need for small projects, but you’ll run out of space quickly if you’re tracking products or monthly sales. Adding or deleting a worksheet takes just a moment, but if you want to delete a worksheet, be sure you’re getting rid of the right one!

Insert a Blank Worksheet

  1. Right-click the sheet tab of the worksheet that follows the location where you want to insert a worksheet.

  2. Choose Insert from the shortcut menu.

  3. Double-click Worksheet.

    Insert a Blank Worksheet

    Tip

    Tip

    If you want to insert a worksheet at the end of the workbook, click the Insert Worksheet button at the right edge of the tab bar.

Delete One or More Worksheets

  1. Hold down the Ctrl key and click the sheet tabs of the worksheets you want to delete.

  2. Right-click the selection.

  3. Choose Delete from the shortcut menu.

  4. Click Delete to confirm that you want to delete the worksheet.

    Delete One or More Worksheets

    Caution

    Caution

    If you have data in the worksheet that you want to delete, deleting the worksheet will erase all the data in that worksheet. This operation is not reversible.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.135.206.254