How to Send a Single Excel Worksheet by Email in Microsoft 365
Question details
The user wants to email only one specific active worksheet from an Excel workbook rather than the entire file, but the legacy feature to do this directly is missing in newer versions of Microsoft 365.
- Product
- Microsoft Excel (Microsoft 365)
- Device & OS
- not provided
- Scenario
- Sending a single spreadsheet page to an email recipient without manually saving separate temporary files or printing and scanning.
- Observed behavior
- The built-in option to 'Send' only the active worksheet by email is unavailable, forcing users to send the whole workbook or look for complex workarounds.
Ensure you are using the desktop version of Microsoft Excel, as Excel for the web does not fully support the desktop email integration features required for these workarounds.
Copy the Worksheet to a New Workbook and Send
This is the most straightforward workaround to send just one worksheet by manually isolating it into a new file before emailing.
Since Microsoft 365 removed the direct 'send active sheet' button, you must first isolate the sheet. By adding the Send command to your ribbon, you can quickly email this new isolated workbook without needing to save it to your hard drive first.
Go to 'File' > 'Options' > 'Customize Ribbon'. Under the 'Choose commands from' dropdown menu, select 'All Commands'. Scroll down to find 'Send' and add it to a new custom group on your Ribbon.
Right-click the worksheet tab you want to send and select 'Move or Copy'. Check the 'Create a copy' box, click the 'To book' dropdown, and choose '(new book)'. Click OK.
In the newly created workbook (which now contains only your target sheet), click the 'Send' command you just added to the Ribbon. This will open your default email client with the single-sheet workbook attached.
Automate the Process with a VBA Macro
If you frequently need to send single sheets and want a one-click solution, a VBA macro can automatically extract and email the active sheet.
Try WPS Office for Easy File Sharing and Management
If you are frustrated by missing legacy features or complex workarounds in Microsoft 365, WPS Office offers a free, lightweight, and highly compatible alternative. It provides intuitive file management and straightforward sharing options in a highly familiar user interface.
Frequently Asked Questions
Why can't I find the option to send a single sheet in Microsoft 365?
Microsoft has updated its sharing features in newer versions of Microsoft 365, prioritizing cloud-based OneDrive links and co-authoring over traditional email attachments. As a result, the legacy feature to directly attach a single active sheet to an email was removed from the default interface.
Does this workaround apply to Excel for the web?
No, Excel for the web does not support the same desktop email application integration (like Microsoft Outlook). You will need to use the Excel desktop application to utilize the custom 'Send' command or run VBA macros.
Can I use the standard 'Share' button instead of the 'Send' command?
The standard 'Share' button in Microsoft 365 typically shares the entire workbook via a OneDrive link or sends the whole file as a PDF or Excel attachment. It does not allow you to isolate and send a single worksheet.
