How to Send an Editable Excel Spreadsheet by Email (3 Methods)

Below is the dataset that represents the quarterly sales of some stationery products.


Method 1 – Use the Share Option to Send an Editable Excel Spreadsheet

Steps:

  • Right-click on the sheet title.
  • Select Move or Copy from the Context menu.

A dialog box will open.

Using Share Option to Send an Editable Excel Spreadsheet by Email

  • Select (new book) from the To book drop-down box.
  • Mark Create a copy and press OK.

Using Share Option to Send an Editable Excel Spreadsheet by Email

That spreadsheet is copied and opened to a new workbook with the default name ‘Book1’.

  • Click on the File tab.

Using Share Option to Send an Editable Excel Spreadsheet by Email

  • Click on Share from the options.

Using Share Option to Send an Editable Excel Spreadsheet by Email

  • Click Excel Workbook from the ‘Attach a copy instead.’

It will take you to Microsoft Outlook to send the email.

  • Type the email address in the ‘To’ section and press Send.

Using Share Option to Send an Editable Excel Spreadsheet by Email

Read More: How to Send Excel File to Email Automatically


Method 2 – Use the Quick Access Toolbar to Email an Editable Spreadsheet As an Attachment

Steps:

  • Click the Customize Quick Access Toolbar icon.
  • Select More Commands from the list.

Using Quick Access Toolbar to Send an Editable Excel Spreadsheet As an Attachment by Email

  • Select All Commands from the ‘Choose commands from’ drop-down box.
  • Scroll down, select Send, and press Add.

Using Quick Access Toolbar to Send an Editable Excel Spreadsheet As an Attachment by Email

  • Press OK.

Using Quick Access Toolbar to Send an Editable Excel Spreadsheet As an Attachment by Email

Here’s our added command in the toolbar.

Let’s send the email.

Using Quick Access Toolbar to Send an Editable Excel Spreadsheet As an Attachment by Email

  • After getting the Microsoft Outlook dialog box, type the email address in the ‘To’ section.
  • Press Send.

Read More: Automatically Send Emails from Excel Based on Cell Content


Method 3 – Use the Quick Access Toolbar to Send an Entire Workbook

Steps:

  • Click on the Send command from the toolbar.
  • Select Email from the list.

Using Quick Access Toolbar to Send an Entire Workbook by Email

The entire workbook has been added as an attachment.

  • Type the email address and press Send.

Read More: How to Send Multiple Emails from Excel Spreadsheet


Download the Practice Workbook

You can download the free Excel template here and practice.


Related Articles

<< Go Back To Send Email from Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Sourov Hossain Mithun
Md. Sourov Hossain Mithun

Md. Sourov Hossain Mithun, an Excel and VBA Content Developer at Softeko's ExcelDemy project, joined in October 2021. Holding a Naval Architecture & Marine Engineering degree from BUET, Mithun showcases expertise during his two-year tenure. With over 200 published articles on Excel topics, he earned a promotion to Team Leader, excelling in leading diverse teams. Mithun's passion extends to Advanced Excel, Excel VBA, Data Analysis, and Python programming, contributing significantly to the innovative and dynamic environment of ExcelDemy... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo