Email a Single Excel Worksheet from a Workbook

Sometimes, you may need to send a part of the worksheet or a single excel worksheet from the workbook to your colleague or boss. If you want to e-mail a single worksheet from a workbook. Then, instead of saving a copy of that workbook and deleting the unwanted content. Here is a quicker way to do it:

Note: This will only work when Outlook is set up on your computer.

1. Select the worksheet/tab you want to e-mail or If you want to send more than one worksheet, then hold down the Ctrl key & click on the each worksheet which you want to send in e-mail. Then,
2. Right-click on the selected worksheet/tab and Click on the Move or Copy option (as shown in below screenshot). Then,
   
   
   
    
    
3. In the To book: field select (new book) and check mark the Create a copy option and Click on OK button (as shown in below screenshot)
   
   
   


4. The worksheet/s will now be opened in a separate workbook with a default name, i.e. Book1.
5. In this workbook, Go to File > Share > Email > click on Send as Attachment option (as shown in below screenshot).
6. Six