Scroll Down and select Send to Mail Recipient option.In the Excel Options dialogue box, select All Command in the ‘Choose Command from’ drop down.Right click on any of the ribbon tabs and select Customize Quick Access Toolbar.This will enable the functionality to send a single Excel worksheet or a part of the worksheet as the Email attachment.

You need to add an icon to the Excel Quick Access Toolbar. While there can be other ways of doing this, in this tutorial, I’ll show you the fastest and the easiest way to email a single Excel worksheet or a part of the worksheet. Sometimes, you may need to send a part of the worksheet or a single excel worksheet from the workbook to your colleague or boss. These could be separate sheets in the same workbook (for example different worksheets for different years, products, departments, etc.). We often create and work on multiple Excel worksheets.