Don’t forget to share this post

Recent versions of Microsoft Excel, including 2010, 2013, and 2016, allow users to easily share an Excel file for multiple users to edit. However, to collaborate with others online on the same version, Microsoft introduced Co-Authoring in Excel 365. In addition to unlocking powerful new collaboration features, users can still enjoy the more traditional methods of sharing, such as sending your Excel file to your coworker’s email.

In this article, you’ll learn how to email an Excel spreadsheet following multiple solutions. If you’re interested in only sending part of the spreadsheet, you’ll see how to quickly email an Excel sheet or how to attach an Excel file to an email in case you want to share the whole document.

Layer Google Sheets Add On
Get Started With Layer Today!

Share parts of your Google Sheets, monitor, review and approve changes, and sync data from different sources – all within seconds.

GET STARTED FOR FREE

How to email an Excel sheet?

If we use Excel spreadsheets for work, then it’s likely that our data is structured into various sheets within an Excel file. If this is the case, then we might also be interested in sharing only part of the file with a coworker. First, you’ll see how to send part of your data by email.

How to send part of an Excel spreadsheet by email?

Let’s say I have an Excel file containing the list of clients gained per month, where each worksheet represents the month. To speed up the sending process, it’s important to add the “Send to Mail Recipient” option to the “Quick Access Toolbar”.

How to add Send to Mail Recipient to the Quick Access Toolbar in Excel?

  1. 1. Open the Excel file containing the data to send, and click on the “Customize Quick Access Toolbar” drop-down arrow, as shown below.
How to Email an Excel Spreadsheet Multiple Solutions Customize Quick Access Toolbar
How to Email an Excel Spreadsheet (Multiple Solutions) - Customize Quick Access Toolbar
  1. 2. To customize the toolbar, select “More Commands…”.
How to Email an Excel Spreadsheet Multiple Solutions More Commands
How to Email an Excel Spreadsheet (Multiple Solutions) - More Commands
  1. 3. From the “Excel Options” dialog box, click on the “Choose command from” drop-down menu and select “Commands Not in the Ribbon”.
How to Email an Excel Spreadsheet Multiple Solutions Commands Not in the Ribbon
How to Email an Excel Spreadsheet (Multiple Solutions) - Commands Not in the Ribbon
  1. 4. Scroll down the list of options until you find “Mail Recipient [Send to Mail Recipient]”. Select it.
How to Email an Excel Spreadsheet Multiple Solutions Add Mail Recipient
How to Email an Excel Spreadsheet (Multiple Solutions) - Add Mail Recipient
  1. 5. Click on the “Add >>” button, to include in the list to the right, where your current Quick Access Toolbar options appear. Once you finish, click “OK” at the bottom.
How to Email an Excel Spreadsheet Multiple Solutions Click OK
How to Email an Excel Spreadsheet (Multiple Solutions) - Click OK
  1. 6. Select the cell range to send via email and then click on the newly created “Mail Recipient [Sent to Mail Recipient]” icon in the Quick Access Toolbar, as shown below.
How to Email an Excel Spreadsheet Multiple Solutions Click on Mail Recipient
How to Email an Excel Spreadsheet (Multiple Solutions) - Click on Mail Recipient
  1. 7. You should now be able to choose between two sending options, “Send the entire workbook as an attachment” or “Send the current sheet as the message body”. Click on the second option to send the selected range as the body of the email. Click “OK” to finish.
How to Email an Excel Spreadsheet Multiple Solutions Send as email body
How to Email an Excel Spreadsheet (Multiple Solutions) - Send as email body
  1. 8. Enter the ‌information in the opened email prompt. Once you’ve finished, click on “Send this Selection” to send your selected range to your coworker.
How to Email an Excel Spreadsheet Multiple Solutions Send this Selection
How to Email an Excel Spreadsheet (Multiple Solutions) - Send this Selection

Although it maintains parts of the Excel spreadsheet interface, the data no longer has Excel functionalities, so recipients will need to edit the data by opening it in Excel.

But what if you want to send the whole worksheet and not a specific cell range? Let’s explore this option now.

How to Share an Excel File for Multiple Users?

There are different ways to share an Excel file. Here's how to share an Excel file with multiple users for easy collaboration

READ MORE
How to Share an Excel File for Multiple Users

How to send a single Excel worksheet as an email attachment?

In case you would like to send a single Excel worksheet as the email attachment, you’ll need to “Copy” the worksheet to a new workbook.

How to Move or Copy a single Excel worksheet to a separate workbook?

  1. 1. Right-click on the worksheet you’d like to send and select “Move or Copy”.
How to Email an Excel Spreadsheet Multiple Solutions Move or Copy
How to Email an Excel Spreadsheet (Multiple Solutions) - Move or Copy
  1. 2. Select the sheet to send and then tick on the “Create a Copy” option below the sheet list.
How to Email an Excel Spreadsheet Multiple Solutions Create a Copy
How to Email an Excel Spreadsheet (Multiple Solutions) - Create a Copy
  1. 3. Click on the drop-down “To book” menu and select “(new book)”. Click “OK” to finish.
How to Email an Excel Spreadsheet Multiple Solutions new book
How to Email an Excel Spreadsheet (Multiple Solutions) - (new book)
  1. 4. Now, you can click on the previously created “Mail Recipient [Send Mail to Recipient]” option in the Quick Access Toolbar. Similar to the previous section, you’ll be prompted to choose the sending method. Here, you need to select the first option to send the entire workbook as an attachment. Click “OK”.
How to Email an Excel Spreadsheet Multiple Solutions Send entire workbook
How to Email an Excel Spreadsheet (Multiple Solutions) - Send entire workbook
  1. 5. Continue entering the email recipient(s) and the message body if needed.
How to Email an Excel Spreadsheet Multiple Solutions Email info
How to Email an Excel Spreadsheet (Multiple Solutions) - Email info

So far, you have seen two different methods to send data contained in a spreadsheet. Let’s now see three different ways to attach an Excel file to an email.

How to attach an Excel file to an email?

If you want to send the whole spreadsheet, then the fastest way is to send it as an attachment. Here, you’ll learn how to attach Excel files to emails according to three useful ways.

How to attach an Excel file using “Send as Attachment”?

The “Send as Attachment” is a useful built-in feature that can be added to the Quick Access Toolbar, as previously shown with the “Mail Recipient” option.

How to add Send as Attachment to the Quick Access Toolbar in Excel

  1. 1. Follow steps 1 - 3 from the first section of this article.
  2. 2. Select “Email”, aka “Send as Attachment” from the list of options, then “Add >>”. Click “OK” to finish.
How to Email an Excel Spreadsheet Multiple Solutions Add Email
How to Email an Excel Spreadsheet (Multiple Solutions) - Add Email
  1. 3. On the Excel file, click on the “Email” option now available in the Quick Access Toolbar, as shown below.
How to Email an Excel Spreadsheet Multiple Solutions Select Email
How to Email an Excel Spreadsheet (Multiple Solutions) - Select Email
  1. 4. The email prompt will show, including the Excel file attachment. Enter the remaining information on the recipient(s) and the message and click “Send” to finish.
How to Email an Excel Spreadsheet Multiple Solutions Send
How to Email an Excel Spreadsheet (Multiple Solutions) - Send

Although this is a quick method, most users prefer alternative options. This is because “Send as attachment” does not allow any edits once it has been sent. As a result, users can end up with different versions of the same data. What’s more, this option does not integrate Gmail or other email applications, and you can only attach one file at a time. Now, you’ll learn how to attach an Excel file from Microsoft Outlook using the Recent Items feature.

How To Share Only One Tab in Google Sheets
How To Share Only One Tab in Google Sheets

When sharing a Google Sheets spreadsheet Google usually tries to share the entire document. Here’s how to share only one tab instead.

READ MORE

How to attach an Excel file using Recent Items?

Since you’ll likely want to attach an Excel file that you are currently working on, here’s a quick method to attach the most recent file in Outlook 365.

  1. 1. Open Microsoft Outlook application and press Alt + H + A + F. This shortcut will automatically prompt the “Recent Items” list. Press “Enter” in case the file to attach is the first. If not, scroll down and click on the file you wish to attach.
How to Email an Excel Spreadsheet Multiple Solutions Alt H A F
How to Email an Excel Spreadsheet (Multiple Solutions) - Alt + H + A + F
  1. 2. Outlook prompts a message, so you can choose between sharing it as a link or attaching a copy. Click on the second option to attach.
How to Email an Excel Spreadsheet Multiple Solutions Attach as copy
How to Email an Excel Spreadsheet (Multiple Solutions) - Attach as copy

By selecting the “Share link” option, you can send an Excel spreadsheet that can be edited and make use of the Co-Authoring feature. This last method illustrates how to attach an Excel file by copying and pasting the file path.

How to attach an Excel file using the File Path?

This method is usually the preferred one as it’s compatible with any email application and file format.

  1. 1. Open the Excel file you’d like to attach. Then go to File > Info to copy the file path.
How to Email an Excel Spreadsheet Multiple Solutions File Info
How to Email an Excel Spreadsheet (Multiple Solutions) - File > Info
  1. 2. Click on the “Copy path” button to the right of the “Share” button.
How to Email an Excel Spreadsheet Multiple Solutions File Info 2
How to Email an Excel Spreadsheet (Multiple Solutions) - File > Info
  1. 3. Go to your email and click on the “Attach” button, then “Browse This PC”.
How to Email an Excel Spreadsheet Multiple Solutions Browse this PC
How to Email an Excel Spreadsheet (Multiple Solutions) - Browse this PC
  1. 4. Click on the “File name” field and press Ctrl + V to paste the file path you just copied. Click “Insert” to attach the file to your email.
How to Email an Excel Spreadsheet Multiple Solutions Copy File name
How to Email an Excel Spreadsheet (Multiple Solutions) - Copy File name

Note that this method can be used with any other email platform, including Gmail or Yahoo. If you have encountered any other issues when trying out these methods, you might find this Microsoft support page useful.

How to Share Parts of Your Google Sheets?

Layer is an add-on that equips you with the tools to increase efficiency and data quality in your processes on top of Google Sheets. Share parts of your Google Sheets, monitor, review and approve changes, and sync data from different sources – all within seconds. See how it works.

Using Layer, you can:

  • Share & Collaborate: Automate your data collection and validation through user controls.
  • Automate & Schedule: Schedule recurring data collection and distribution tasks.
  • Integrate & Sync: Connect to your tech stack and sync all your data in one place.
  • Visualize & Report: Generate and share reports with real-time data and actionable decisions.

Limited Time Offer: Install the Layer Google Sheets Add-On today and Get Free Access to all the paid features, so you can start managing, automating, and scaling your processes on top of Google Sheets!

Conclusion

Although Microsoft has made it easier to collaborate through its various apps, there are always useful shortcuts and solutions that help speed up daily tasks like attaching large files to emails.

You’ve seen how to email an Excel spreadsheet using multiple solutions, including how to send part of an Excel sheet and how to send a single Excel worksheet through Quick Access Toolbar add-ins. To share the entire Excel spreadsheet with a coworker, Microsoft helps you speed up the process through its “Send as Attachment” feature in Excel or the “Recent Items” feature in Outlook. If you prefer using another email application, the “Copy Path” option is the most efficient and flexible solution.

Layer Google Sheets Add On
Get Started With Layer Today!

Share parts of your Google Sheets, monitor, review and approve changes, and sync data from different sources – all within seconds.

GET STARTED FOR FREE
Hady ElHady
Hady is Content Lead at Layer.

Hady has a passion for tech, marketing, and spreadsheets. Besides his Computer Science degree, he has vast experience in developing, launching, and scaling content marketing processes at SaaS startups.

Originally published Dec 7 2022, Updated Nov 29 2022